General discussion

Locked

Corrupted Access DB...HELP

By MJA ·
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....

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Corrupted Access DB...HELP

by DKlippert In reply to Corrupted Access DB...HEL ...

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?

Collapse -

Corrupted Access DB...HELP

by MJA In reply to Corrupted Access DB...HEL ...

No its a table...

Collapse -

Corrupted Access DB...HELP

by jboardman In reply to Corrupted Access DB...HEL ...

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.

Collapse -

Corrupted Access DB...HELP

by MJA In reply to Corrupted Access DB...HEL ...

No its a table...

Collapse -

Corrupted Access DB...HELP

by RichTee In reply to Corrupted Access DB...HEL ...

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

Collapse -

Corrupted Access DB...HELP

by MJA In reply to Corrupted Access DB...HEL ...

Poster rated this answer

Collapse -

Corrupted Access DB...HELP

by shmaltz In reply to Corrupted Access DB...HEL ...

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.

Collapse -

Corrupted Access DB...HELP

by MJA In reply to Corrupted Access DB...HEL ...

Poster rated this answer

Collapse -

Corrupted Access DB...HELP

by MJA In reply to Corrupted Access DB...HEL ...

This question was closed by the author

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Forums