Unhide Tables and Queries

  • Thread starter Thread starter Doua
  • Start date Start date
D

Doua

Does anyone know how to unhide the Tables and Queries in
an Access database? All my tables and queries are
disappeared, I don't know what caused it. However, my
forms are still working.

I don't think that they were been deleted, because if
they were my forms would not be able to pull anything
more datas. I suspected that they were hidden, which I
can't seem to unhidden them.

Any help would be greatly appreciated.

Thanks,

Doua
 
They are probably hidden.

Try the Menu Tools / Options / View tab and check the
option Show Hidden Objects. OK to get ot of the Options
dialog.

Hidden Tables & Queries should now be visible. Go through
each hidden Object and uncheck its "Hidden" Property.

HTH
Van T. Dinh
MVP (Access)
 
Have you tried choosing;

Tools, Options

From the menu and make sure that 'Hidden' and 'System' objects are ticked...

Not sure what may have caused it, but if you right click on the table and
choose 'Properties', you can make the attribute of the table, hidden. Also,
to hide tables, you can prefix them with uSys. But obviously, this has not
happened, as your forms and queries would need to have the recordsource
changed, as the name of the table would have changed.
 
Back
Top