How do I set up security permissions for an Access database?

[Reg614]

I need to set up security access to a database, and really don't know how to
do it. I have two people, other than myself, sharing access to this
database. I want to assign myself as administrator, and the others as data
input users, without permission to open the database to change the design.
Could someone step me through this process in layman's terms?
Thanks!

 

[Lynn Trapp]

Get a copy of the Security FAQ, read it several times, and follow it to the
letter. There is a link to it on theSecurity page of my website.

 

[Rick B]

Sounds like you may just want to create an mde file. This locks the user
out of most of the design options.

You would keep the MDB file so you can make changes to the design and then
release a new mde file when needed.

Rick B

 

[Reg614]

Lynn,
I attempted to open your link, but it didn't work. Do you have another way
to access your security page? The website stated it was under development.

 

[Reg614]

What is the best way to make the file a MDB file?

 

[Lynn Trapp]

It works fine for me. Perhaps the hosting site was down temporarily.