Compacting Error

[Caroline]

While compacting a database I got an error message:

"Could not find field 'Description', MSysObjects"

The database is now missing about 200 files. But a new
table has been created entitled MSysObjects with about 200
files in it. However, there is no info regarding these
files other than the error message from above.

I'm hoping to recover these files. Does anyone know if
it's possible?

Thanks -
Caroline

 

[Joan Wild]

I suggest you copy the database first.

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing objects from the
old. If Jetcomp succeeds, you should do this anyway.

If that fails, you can try www.pksolutions.com

 

[Alphonse Giambrone]

Look in the same folder as you mdb for another mdb.
When compacting a db via code, it must be compacted into a different file,
then the original deleted and the new one renamed to the original name.
I am guessing that Access does something similar. Your db may just be there
under a different name.