Database Corruption Access 97/2000

With this:

http://www.mvps.org/access/modules/mdl0039.htm

you can Right Click over the MDB and execute a Compact and Repair (since you cannot open it now).

First open the Reg file in Notepad and modify the folder paths ... per instructions.

I use this everyday many times.

mx

I downloaded the file and tried it. with both the compact and decompile options i get the same error message from 97, unreconized database format.

Time for a repair service:

http://www.vb123.com/fixaccess/     ' Recommend you try this first.

>> Testimonial:  https://www.experts-exchange.com/questions/23740208/Repair-Microsoft-Access-database-tables-included-in-db-only-no-forms-rpts-etc.html

http://www.everythingaccess.com/accessdatabaserepair.htm  ' Includes an MDE to MDB service
>> Testimonial https://www.experts-exchange.com/questions/24164728/Why-Can't-I-Open-Several-Forms-in-an-Access-2003-mdb-file.html?cid=238&anchorAnswerId=23768293#a23768293

http://www.accessdatabaserepair.com/

http://www.exefind.com/advanced-access-repair-P1475.html

http://accesstools.narod.ru 

https://www.experts-exchange.com/questions/22765813/Access-2000-Database-Crashes-Urgent-help-needed.html?cid=238&anchorAnswerId=19828102#a19828102   

mx

They recovered but as a 2000 mdb need 97.

PetGuy,

  <They recovered but as a 2000 mdb need 97.>

Expert rockiroads (https://www.experts-exchange.com/M_1708773.html), has answerd your above concern here:
https://www.experts-exchange.com/questions/24355742/convert-access-2000-mdb-to-97.html

So you can assign the points to DatabaseMX for this question to close it.

;-)

Thanks

JeffCoachman

Which service did you use ?

mx

i used the vb123 address, the automated system worked but the report said it was a 2000 file. I sent a message back that I needed a 97 file but have not heard back yet.

Can I just say - before you go forking out for a recovery service...
Using a 2000 FE and 97 backend can result in a state of corruption that is flagged only in 97.
That you can see the database opened in 2000 is immensely useful.
There's absolutely nothing stopping you then importing everything into another MDB (which will be in 2000 format) and then saving that in 97 format and you're back to square one.
If you already have a blank empty backup of your backend (which you really should) then it's even simpler - just a case of inserting directly into it (via SQL statements).

Though I'm sure one of the links you mentioned will have mentioned it - JetComp hasn't been mentioned explicitly.
When you can't open your database in Access JetComp is the next step to attempt to compact without opening it.
However there's every chance it wouldn't fix your particular problem.  But the simple 2000 route will do.
(For the most part backward conversions to 97 work alright - but inserts certainly do).

I was able to recrate a 97 mdb from an old backup. It is called products97. I deleted all the records in each table but can not figure out how to transfer the records from the old database to the new one. I can use the interface but writing SQL statments is beyond me. My store opens in half an hour and this is my cash register! Help!