Coding Table Properties

[mazza]

i distribute an database application with 1 front end and 2 backend databases to customers with reletive sensative pricing information. To keep it out of the wrong hands it is password protected, the shift key is disable etc, however when you link through a new database you can still see the tables. An option is to Hide the tables by setting each table property and selecting the hide tick. However each time I create an update or send it to a user I manually have to go through all the tables.
is there a VBA code I can use in a function?

 

[Meltdown]

Go to Tools > Options, just uncheck the Hidden Objects checkbox to show all your hidden tables in one go, recheck to make then all hidden again.

If you want to use code, look up the SetHiddenAttribute and GetHiddenAttribute methods in the visual basic help section of Access.

No harm to hide the front end of your app, right click the folder it's in, select properties and set the hidden property to True.