Database|Table Security

[davidpkohne]

I was wondering if there was a feature or code, to lock all table, query,
form, report, ect from users who access the DB, however, there is a password
to open the tables more maintenance?

thanks,

 

[Rick B]

You want to lock the users out from everything when they access the DB?
What would they do in the DB if they can't access anything?

On way to lock down particular tasks in your database is to implement
User-Level-Security. Then you can define exactly what each user can and
can't do.

Or you could release an MDE version of the database to your users and keep
an MDB copy for yourself. The MDE would not allow the users to modify the
design. When you make changes to your copy, simply distribute a new MDE.

You may also want to apply User-Level-Security to further lock down what
your users can do.