Software

Ask something
Discussion Locked

Corrupted Access DB...HELP

0 helpful
9 replies

by mja

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access (2000)database that has 6 or so tables in it. One of the tables in the database was printed and then dissapeared. I have backups of the database (2 weeks worth) and when I restore the database the table is missing from each one. Question is .. are the tables part of the main db or is it a separate file? Cannot figure out why it would be missing from the back up db. Many thanks beforehand....

9 replies

by dklippert

Tables can be linked to external sources. Otherwise they are all part of the MDB file.
Was it really a table, or was it the result of a Query?

by jboardman

Are you sure it was a table? Are you getting an error message somewhere that tells you it's missing, or are you looking for a table name that seems to be missing? It could be that you are missing a base query that fed into either another query or a form.

by richtee

It is possible that the table was inadvertently hidden.
Try this: go to Tools | Options | View Tab | put a check in the 'Hidden Objects' box

If the table is still in the database it will now appear in your list.

Good Luck,

Rich

by shmaltz

You sure you backed up the actual DB?
I have seen Access files that are devided (tables in one file and forms querys in another).
If you backed up the right file then you should see the tables in there. Unless your backup doesn't work, but then you shouldn't be able to restore it either.

This discussion is closed to new replies.