MS Access 2000 and hiding toolbars and security

We have a database and want to have 2 levels of access to it. 1 being admin (I.e they can see all the forms, tables, queries and all tool bars, add data and stuff) the other level is user (they can only view data contained in the database)

We want the admin account to see all toolbars and enter data.

We want the user account to see no toolbars at all and only view the data.

The database is a 'split database' (the tables are in one database which is on the server, the reports and queries will be on the users machine. This will make the database quicker)

We can use some VB if we have to but it has to be Access (2000) we aren't aloud to use anything else.

Thank you for your help

 

There are several options under Tools>Startup to prevent/limit the toolbars etc. from showing. (See the check boxes at the bottom of the Startup pop-up box.)

I would suggest you do some reading on how to use these functions as you may very well lock yourself out of the db as well. I haven't used this for some time and forget how to bring up the full tool bars/menu. I think you hold the Shift or Control key down when starting the db to bring up full menu's when.

Edit: Just checked in the Access Help and the keys to bring up the full menu when the Startup is restricted are "Ctrl + F11. This works after the db is loaded.

For your info, go to Help and search on "startup" for a bunch of info.