Record is deleted error

[mssbass]

I am unable to fix my corrupt database. I've tried creating a new database and importing, compacting and repairing, jet compact program, save as dbf, etc. I cannot seem to query my table!! I have approximately 1.2 million records. I keep having "Record is deleted" error. Now I am trying to create a query to query the first 50% of records and the last 50% of records. Of course, I cannot sort the table.

Can anyone help me????????????????????????????????????????????????????????????

 

[danvlas]

Have you tried Decompile?


Backup the db

Start - Run
msaccess.exe /decompile "C:\Path\File.mdb"

If you have more Access versions installed on the computer, you have to indicate the full path of msaccess.exe in the command line.


HTH





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html