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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Donald MaloneyConsultantCommented:
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 Access MVP)Database Architect / Systems AnalystCommented:
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
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

jfgkAuthor Commented:
no it never ran on xp
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
jfgk - did you try JetComp ?  Very easy to download and run.

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Donald MaloneyConsultantCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.