MS Access Security on a Network

[fvevaina]

I have developed an access data and then copied it on to a network. In the network drive I have used the security wizard and granted appropriate permission to to my target users.

The security setup works perfectly from my own computer but does not work from a target user's machine.

Could any one suggest what I am doing incorrectly?

[abolos]

I have developed an access data and then copied it on to a network. In the network drive I have used the security wizard and granted appropriate permission to to my target users.

The security setup works perfectly from my own computer but does not work from a target user's machine.

Could any one suggest what I am doing incorrectly?

It is a matter of rights, so recheck the security of your Win server. If it is Windows 2000 or 2003 then right-click on the folder where the database reside and choose security. By the way, do you have a domain? if yes then this is very easy. Choose whom have a read or write access to your database by choosing the security groups they belong to.

[Lysander]

I have developed an access data and then copied it on to a network. In the network drive I have used the security wizard and granted appropriate permission to to my target users.

The security setup works perfectly from my own computer but does not work from a target user's machine.

Could any one suggest what I am doing incorrectly?

The security system creates an MDW security file and then you join it. You can then set the security for the database. However, another user, on another PC is not automatically joined to the new MDW and so does not have access to the database. Each PC must either join the required MDW or, use something like the following shortcut to access the database via the correct MDW

"C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE" e:\champion\championCode.mdb /wrkgrp Z:\champion\champion.mdw
 

[fvevaina]

It is a matter of rights, so recheck the security of your Win server. If it is Windows 2000 or 2003 then right-click on the folder where the database reside and choose security. By the way, do you have a domain? if yes then this is very easy. Choose whom have a read or write access to your database by choosing the security groups they belong to.

Thanks for your prompt reply to my query. I use Access 2003 and I did try your suggestion. Unfortunately I was not successful. (I have to admit though that I am somewhat of a novice in access).

It seems to me that the problem may not be network- related but perhaps something that needs to be done in access so that the network can allow other users to log in.

Do you feel that it has something to do with the mdw file?

[fvevaina]

The security system creates an MDW security file and then you join it. You can then set the security for the database. However, another user, on another PC is not automatically joined to the new MDW and so does not have access to the database. Each PC must either join the required MDW or, use something like the following shortcut to access the database via the correct MDW

"C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE" e:\champion\championCode.mdb /wrkgrp Z:\champion\champion.mdw
 

Thanks for your quick reply. I have to clarify that I am not too familiar with access code but your suggestion does seem to make logical sense since the security works perfectly on my computer but not on any of the user computers.

I would greatly appreciate it if you would please let me know if I need to copy and paste your suggested code and how this is to be done?

[BradHodge]

If this is a secure database that requires a login with username and password, you might look at this sight. It has several links that will help you as you troubleshoot, and may help you in the future with changes as well.

Microsoft Access Security Page

Brad.

[Lysander]

Thanks for your quick reply. I have to clarify that I am not too familiar with access code but your suggestion does seem to make logical sense since the security works perfectly on my computer but not on any of the user computers.

I would greatly appreciate it if you would please let me know if I need to copy and paste your suggested code and how this is to be done?

The 'code' is the properties of a shortcut to MS Access. What you need to do is find out where the Access exe file is on your pcs and create a shortcut to it. If you right click on the shortcut and select properties, you will see a box labelled 'Target' and it will contain something like this.
'C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE'
This is where I have my version of Access. The default MS installation will be
'"C:\Program Files\MICROS~2\OFFICE11\MSACCESS.EXE" '

Now you have to add the command line parameters to run your system, so you add the path to your database to get this.

"C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE" e:\champion\championCode.mdb

where e:\champion\championCode.mdb is my database.

Now you add the security file to the end, to get

"C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE" e:\champion\championCode.mdb /wrkgrp Z:\champion\champion.mdw


In the above, the database code sits on each PC, in the E:drive, the workgroup security file sits on the server, in the Z: drive, along with the linked data.

Hope that clarifys things

[abolos]

Thanks for your prompt reply to my query. I use Access 2003 and I did try your suggestion. Unfortunately I was not successful. (I have to admit though that I am somewhat of a novice in access).

It seems to me that the problem may not be network- related but perhaps something that needs to be done in access so that the network can allow other users to log in.

Do you feel that it has something to do with the mdw file?

Hi,

Working with the WDM file is good idea but it needs so many attention. Backup the database before starting using the security group in Access.