Changing Security Settings of my Network Shared Database

sehall

New Member
Joined
Dec 30, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

sehall

New Member
Joined
Dec 30, 2005
Messages
2
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

MrExcel MVP
Joined
Jul 7, 2002
Messages
1,212
You could put some code in a startup form to look for someone trying to login in as "Admin"

Code:
  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

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,535
Messages
5,572,747
Members
412,482
Latest member
arooshrana2
Top