Hello guys,
i have designed a database but i am going to put it on cd. How would i go
about assigning usergroups and passwords to this type of database that is
going to be copied from the cd i will burn it on. Basically i want password
protection for this database and assign usergroups such as 'top manager' and
'staff' and just 2 passwords. How can i go about doing this? all advice wud
be fab:)

Kit wrote:
Access User Level Security is not affected by the fact that you will
distribute your files on a CD.  Copying from CD to a hard disk often means
you'll have to reset the Read-Only flag, but other than that Access security
is not affected.

Now if the "CD" part of your question was incidental and you are really
asking "How do I set up security?" I'm afraid that's beyond the scope of a
simple answer in these newsgroups.  Access security has a steep learning
curve.  My suggestion is to visit one of the "step by step" web pages
like...

http://www.ltcomputerdesigns.com/The10Steps.htm

....and experiment on COPIES of your files until you are comfortable with it.

list of users
Users Group and User Permissions
Security warning when opening a file
Patch problem Access 2003 (SP2)
Printing Problem
Moving .mdw file
New security warning messae
How can I get an Access database to use data from an outside Form
Help: Access 2003 not reading the signatures
Set Start up Security to not show Tool Bars and now i can't get in