multiple PCs accessing same database

[floprock]

I'm having a fit trying to get users and groups set up for a certain
database. I set it up on my PC thinking that the settings were just for the
database, not all, but apparently it affected all of my databases on my PC.
I want portable settings I can use for this single database because I want
multiple users to use it, just not edit the forms, etc. How can I do this?

Thanks!
floprock

 

[jbgarrett1]

You can create a workgroup and then bring everyone using the specific
database into the workgroup. With the workgroups you can set access to only
allow certain users to do certain things.
Tools -> Security

 

[Joan Wild]

I'm having a fit trying to get users and groups set up for a certain
database. I set it up on my PC thinking that the settings were just
for the database, not all, but apparently it affected all of my
databases on my PC.

That means that the workgroup file you created (you did create a new one,
right?) is now set as the default one to use for all sessions. Just use the
workgroup administrator to rejoin the standard system.mdw that ships with
Access.

Create a desktop shortcut for the secure mdb. The target would include the
/wrkgrp switch to specify your secure mdw to use, just for that session.
The target would look like:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"