Protecting the database Structure

  • Thread starter Thread starter BruDe
  • Start date Start date
B

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.
 
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.
 
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.
 
Back
Top