97 to 97 unrecognized database format

I'm trying to open a 97 access db with access 97 on win XP and I'm getting the Unrecognized Database format error....  ???
jfgkAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
jfgk - did you try JetComp ?  Very easy to download and run.

mx
0
 
donaldmaloneyCommented:
Did this application ever run in XP?
If it was running in 2000 there may be an Access add-in that will not be recognized in XP.
Can you open the code to get to the error line?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Try using JetComp.exe on this database:

http://support.microsoft.com/kb/295334

When you run JC ... be sure to specify a *different* Name in the Destination box.

mx
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
OxonDevCommented:
Looks like you've got a corrupt file.  Allen Browne's website has a series of pages on corruption issues:
http://allenbrowne.com/tips.html (bottom of page).  

If this doesn't work, there are a number of web based services where you can upload a corrupt file and they'll recover them for a fee.  Three years ago I had a file which became unstable over a period of time, rendering backups useless.  After 7 days intensive development with 24hours to a deadline, I bit the bullet and paid http://www.everythingaccess.com/ to recovery the file.  I got everything back except a problem form, it's associated report, & some custom command bars.  This enable me to retrace my steps & deliver on time so it depends on your need.

Going forward, if you're doing lots of development work, it would be worth doing daily backups, or automated rebulds of your files.  Allen also has some interesting ponts about avaiding corruption in the first place: http://allenbrowne.com/ser-25.html.
0
 
jfgkAuthor Commented:
no it never ran on xp
0
 
donaldmaloneyCommented:
So,
Some information.
What OS was it running under?
Is it a compiled version of Access97 with runtime?
Or running native 97?
Is there Access 97 security controling it?
Does it need files other than the MDB access database?
e.g. are there links to other files like excel?

In XP are you still running Access 97?

Can you get to all the code/forms/reports etc.
Are the two pc's connected to a comon server and can they see each other?
Hav eyou tried to open an access DB on th eXp machine and then import all forms/modules/queries/reports/macros/files?
This will sometimes bring over the whole DB and then you can run it on the xp machine.

It's been awhile since I used 97 but I n tools I think ther emay be a button to compact and repair the DB.

0
All Courses

From novice to tech pro — start learning today.