Lost Data and Table

[Manjeeth Kidiyoor]

Hi Guys,

I had created an Access Database which had 6 tables in it. It was working all fine for a month and it was around 16000 KB.

Now all of a sudden the tables has been disappeared and I could see only 1 table named "msyscompacterror" . but the size is still 16000 KB.

Could you guys please help me in recovering the lost tables and data.
It would be a great help for me if I get my data back.

 

[pbaldy]

In the same location, is there a file named Database1 or something like that? The compacting process makes a copy. Hopefully you also have backups.

 

[Ranman256]

Make daily backups.

 

[sneuberg]

You could try to create a new database and then see if you can import the tables from the botched database,

 

[The_Doc_Man]

First, COPY the DB file before trying anything else.

Next, using the COPY of your DB, try to open the (one) table that you have, the 'mSysCompactError' - because Access writes error messages in it. If there IS a message (or more than one), see what it is trying to tell you. After that, you might have a better idea of what went wrong.

Sometimes it is possible to re-attempt the Compact and Repair operation "from the outside" by opening Access directly rather than launching a DB. You then go to the file menu and try to C&R your database by clicking the Compact & Repair button, then letting it ask you what file to work on. Work on the COPY! Don't do anything else to the original.

Steve's suggestion about attempting to import data from the bad database to a new, blank database could also work, but it will depend on WHY your DB barfed, and that information is in that mSys table. Reply in this thread with any error message it might have. If it names many messages, look at them and try to report the unique errors. We don't need a thousand copies of the same error, once for each object in the DB file.