Discussion Locked

Securing Access 97

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
The most effective way to hide the tables from the end user

8 replies

by dklippert

Depending on the level of sphistication of your user, you could go to Tools Startup (I think that was in 97, and choose to hide the database window. Of course, just hitting F11 will bring it back up.
Another way is to name the table starting with the letters "USYS". The tables will nit be shown unless Tools>Options>Show System objects is checked.
in Access 97, you can right-click on any object
With Access 97, you can right-click on any object in the database window, and select Properties from the menu, then set the
object's Hidden attribute, it will disappear from the screen if the General
Option to Display Hidden Objects is not selected.

by eebee

You could work with splitted databases:
One containing the data and one containing the queries, forms, reports...
DON'T ATTACH the tables, instead, create queries linked to the tables in the external file like this:

SELECT * FROM [TableName] IN'[Full path to the file containing the data]';

example: SELECT * FROM Users IN 'd:\My Documents\MyData.mdb';

do not use the '[]' in your query.

Hope this will work for you
eeBee

by timfox

I use the 'ChangeProperty "AllowBypassKey", dbBoolean, False' statement within VBA code that checks a custom login. If I use an Admin login, then I set the property to True, allowing me to access a developer-side back-door to my application. You must also make the appropriate settings in the Tools,Startup screen such as clearing the 'Display Database Window' checkbox etc.

This will hide tables and all other forms, queries etc from the user. I also create an MDE file which I only then distribute to end-users.

by timfox

Splitting databases, making mde files and hiding tables by renaming them to sys objects, will only prevent good users from accessing tables etc. This approach alone will not prevent the hackers or curious users.

This discussion is closed to new replies.