Unhide Tables and Queries

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
 
V

Van T. Dinh

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)
 
R

Ruskin Hardie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top