Hide tables from users

[StephHansen]

How do I hide the tables from users so that when they open the app, they only see the forms?

Stephanie

 

[JerryKlmns]

Create a startup form, from where you open other forms-reports-queries. Desable ByPassShift key (include code to enable it back). Apply user-level security, compile the database. Take a safe backup. And then make it an MDE file.

A keyword search will provide many posts. If you get stucked anywhere in this process feel free to post!

 

[PHV]

Brute force method in VBA:
For Each tdf In CurrentDb.TableDefs
tdf.Attributes = tdf.Attributes Or dbHiddenObject
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fneily]

Or, just for the heck of it, you can add Usys to the front of your table name. Of course, you also have to change all the references to it in your forms, queries, reports, etc. So if you make tblEmployees, UsystblEmployees, it disappears.

 

[Bennie47250]

If you use fneily method of adding Usys to the front of it, how do you get it back if you need to modify the table?

 

[fneily]

Tools-Options, check System Objects under the view tab. Or just say Abracadabra.