jfgk
asked on
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.... ???
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
http://support.microsoft.com/kb/295334
When you run JC ... be sure to specify a *different* Name in the Destination box.
mx
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.
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.
ASKER
no it never ran on xp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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/repo rts/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.
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/repo
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.
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?