Changing Security Settings of my Network Shared Database

[sehall]

I have created a database that will be accessible to multiple users over a network. I followed the steps to setup a new workgroup, add users & groups, and set permissions for each of these users.

My problem is that if a user does not join my new workgroup they are able to open the database under their default workgroup with administrator permissions. Can I change a setting in my database to only allow members of my new workgroup access to the database?

Thanks in advance for any help you can provide,
Steve

 

[CT Witter]

First set a password for the default admin account

You then need to make sure that you have another account as an administrator.
Then log-in under that account and remove the default admin account from the administrator's group.

see
http://www.moretools.com/lessons/access_security.htm
http://support.microsoft.com/default.aspx?scid=/support/Access/Content/SECFAQ.asp&SD=GN&FR=0
for more info.

HTH,
CT

 

[sehall]

I followed these steps and computers on my network that are using the old workgroup info are still able to fully access the database. How can I stop this?

 

[CT Witter]

You could put some code in a startup form to look for someone trying to login in as "Admin"

  If CurrentUser = "Admin" Then
    MsgBox "You Must Login as a Valid account to use this database!", , "Error: Must Have a User Account!"
    Application.Quit
    Else
'User Can use Db
    End If

HTH,
CT

 

[SydneyGeek]

I like CT's code but it has one drawback -- users who hold down the Shift key will open the database with full permissions, unless you have prevented that in code.

Another approach is to change the workgroup file. The following is just a summary -- post back or send a PM if you want more details.

1. Give the Users group Read-only access to the database
2. Create a new group with a different name -- eg My Users . Give the group a PID and write down both the new group and the PID. You will need them later.
3. Put all of your registered users in the My Users group. Unregistered users will come in as Admin, and have read-only access. Registered users will come in as members of My Users, and have read-write access (and whatever other permissions you set for them)

Denis