Software

Ask something
Discussion Locked

Hiding Tables in Access Project (adp)

0 helpful
1 reply

by greg.rojas.ctr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone know how to hide tables in an adp file? Basically if the user is savvy enough to hit F11 or hold Shift when opening, they get all views. We were able to disable F11, but yet they can still hold Shift when opening and see the SQL tables. Can this be prevented?

1 reply

by russell.fox

Put "Usys" at the front of the table name to make it a hidden system object. For example, if you have a table called "tblEchidnas", change it to "UsysTblEchidnas". This is not iron-clad security: a savvy user can change their settings to show hidden & system objects (Tools->Options, two checkboxes).

This discussion is closed to new replies.