Hidden Tables

[George]

We have a database at work that was created by a retired employee. It has a
front end and back end that runs on a LAN. There are some new functions we
want added so rather then mess with his front end I want to create my own
program to tap the the tables in his back end program. When I open the back
end table I don't see any tables is it possible to hide them, when I open the
relations table I see there are twenty three tables.

Thanks

 

[Roger Carlson]

Yes, you can hide tables, either through the Access UI or in VBA code. To
hide a table, select the table in the Database Window and choose Properties.
There is a check box to hide the table. To see hidden tables, go to Tools >
Options and check the Hidden Objects check box.

If the table was hidden through code, it can only be unhidden through code.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[George]

That worked - I added the missing check mark in Tools > Options > Hidden
Objects and all the tables appeared, pure genius...

Thanks