Tables Disappear

[sturner333]

I have an Access file which is the Master for the replicated back-end of my
project. I tried to open it and I see no tables listed. The size of the file
is still 69mb. I can even synch with it. Any ideas? Thanks

 

[Jerry Whittle]

Which version of Access? If 2003 and earlier, make sure that you are in
Tables in the database window. Then make sure to scroll up/down or left/right
using any scroll bars to see if they are hiding to the side.

If that doesn't work, go up to Window unhide and see if they are hidden there.

If even that doesn't work, go to Tools, Options, View tab and check Hidden
and System Objects. Does that bring them back?

If not, make a backup of the database file. Then run a Compact and Repair to
see if there is a corruption problem hiding the tables.

If Access 2007, which doesn't have the good old database window, reply here
and we'll try to work through it.

 

[sturner333]

Thanks.
It was a compact and repair problem.

Which version of Access? If 2003 and earlier, make sure that you are in
Tables in the database window. Then make sure to scroll up/down or left/right
using any scroll bars to see if they are hiding to the side.

If that doesn't work, go up to Window unhide and see if they are hidden there.

If even that doesn't work, go to Tools, Options, View tab and check Hidden
and System Objects. Does that bring them back?

If not, make a backup of the database file. Then run a Compact and Repair to
see if there is a corruption problem hiding the tables.

If Access 2007, which doesn't have the good old database window, reply here
and we'll try to work through it.