Limit Access

[Bigtony]

I want to make a way to make sure nobody can change the
design of our database without a password, but I want them
to be able to view both forms and tables and make data
entry into both.

How do I do this?

 

[Joan Wild]

You can implement user level security, such that users require no login to
use it, but the developer will to make changes.

Download and study the Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
where you'll find the information on how to setup security without the users
having to login.