Access Security on Network Drive 1

[davehill52]

I have a database:
\\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\D11b DA Data Repository Application.mdb

That I have set up security using the Security Wizard. I have added a User (not myself) and given him the same rights I have (Admin).

I am able to Log into the Database from my PC, but when at his PC he gets the following message.

You do not have the necessary permissions to use the '\\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\D11b DA Dat Repository Application.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

Does anyone have a clue what I am missing?

Dave

 

[PHV]

Did you create a MDW for your DB ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davehill52]

The Security Wizard creates the .mdw file
It is located in a sub-folder:
\\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\Data Files\Security.mdw

I can access the user profile and update them.

 

[PHV]

Does the other PC use this .mdw file when opening the .mdb ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davehill52]

How does the other PC User use the .mdw file when opening the .mdb file?

I have asked him to open the .mdb file thinking it would know it is secure and look at the .mdw file for the permissions.

Am I doing something wrong?

Dave

 

[PHV]

The security wizard should have created a shortcut for this.

You may also create a shortcut:
"\path\to\access.exe" "\\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\D11b DA Data Repository Application.mdb" /wrkgrp "\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\Data Files\Security.mdw"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davehill52]

Thanks PH.

I'll try your suggestions.

Dave