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 shabirqadir
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 shabirqadir
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
by shabirqadir
by shabirqadir
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending