By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

MS Access Security on a Network

P: 6
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?
Jul 23 '07 #1
Share this Question
Share on Google+
7 Replies


P: 65
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.
Jul 24 '07 #2

Expert 100+
P: 344
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
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE" e:\champion\championCode.mdb /wrkgrp Z:\champion\champion.mdw
  2.  
Jul 24 '07 #3

P: 6
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?
Jul 24 '07 #4

P: 6
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
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files\Office2000\OFFICE11\MSACCESS.EXE" e:\champion\championCode.mdb /wrkgrp Z:\champion\champion.mdw
  2.  
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?
Jul 24 '07 #5

BradHodge
Expert 100+
P: 166
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.
Jul 24 '07 #6

Expert 100+
P: 344
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
Jul 25 '07 #7

P: 65
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.
Jul 26 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.