Protecting the database Structure

[BruDe]

I've seen a few databases with this feature but never tried to
implement it. What I want to do is provide a button on the
switchboard that allows access to the tables, queries and
forms for changes. When I click on this (database
maitenance) button I want it to prompt me for a password. I
tried the security wizard, but it asks for a password to open
the database, I don't want the users to have to enter a
passowrd to open the database, I just want to protect the
structure from changes by the users.

 

[Rick B]

Why don't you just give that change access to the people who can do it? Why
make your system administrator (for example) enter a password? Just don't
give design rights to the average user.

In my database I only have a couple of people who can change the design of
the objects, or even delete data from tables.


Rick B


I've seen a few databases with this feature but never tried to
implement it. What I want to do is provide a button on the
switchboard that allows access to the tables, queries and
forms for changes. When I click on this (database
maitenance) button I want it to prompt me for a password. I
tried the security wizard, but it asks for a password to open
the database, I don't want the users to have to enter a
passowrd to open the database, I just want to protect the
structure from changes by the users.

 

[BruDe]

The database resides on a single computer and this seemed
a viable solution. The primary user isn't sure how to set up
permissions in the database and I have to admit I'm a
newbie at access security. I was able to hide the tables,
etc., but want to take an additional step and password
protect the structure. Any help or links you can provide
would be helpful.