| Chat with a LIVE Microsoft
Access Expert! |
||||
|
|
|||
|
||||
|
||||
|
#1
03-27-2006, 01:00 AM
|
|||
|
|||
|
Coding Table Properties
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? 
|
| Sponsored Links |
|
#2
03-27-2006, 01:43 PM
|
|||
|
|||
|
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. Last edited by Meltdown; 03-27-2006 at 01:45 PM..
|
| Sponsored Links |
 |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to update number field in "many" table from autonumber field in "one" table | sueviolet | Forms | 3 | 11-22-2009 02:14 AM |
| Find Duplicates different than Duplicates deleted | poet_will | Tables | 14 | 06-09-2006 11:03 AM |
| Yet another relationships question | XQuestion | Tables | 5 | 09-09-2005 10:38 AM |
| Cannot see form properties in pivot table view | Hillrg | Forms | 0 | 08-27-2004 12:36 PM |
| Sharing table issue | BIGGY | Tables | 0 | 07-11-2003 09:48 AM |
Linear Mode
