fajita said:
What is the easiest way to setup security for database?
You question suggests that there is an easy way, and easier way, and an
easiest way - none of which are really true.
Security is complex, and requires some study and practice to get it right.
What is the first step? This database will be on a
network with multiple users.
The first step is to download and study the security FAQ.
http://support.microsoft.com/?id=207793
When you think you understand it, practice on a copy of your database.
Other reading:
Security Whitepaper
http://support.microsoft.com/?id=148555
Although the whitepaper is old, it contains information to help you
understand security.
I have outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
As for multiple users, you will want to split your database into frontend
(all objects except the tables) and backend( just the tables/relationships).
You put the backend on the server, and give each user a copy of the frontend
(linked to the backend) on their computer.
You can secure the database first and then split, but if you do, don't use
the database splitter - split it manually. Details at my website.
