Cannot access secured database

[Barb]

I created a workgroup file which is located locally on my
hard drive. I set myself as the administrator. Only I
can open the file from the shortcut for the workgroup
file. But the other users cannot open it; The users have a
shortcut to the database itself.

When they try to access it, they receive the following
error:
"You do not have the necessary permissions to use
the 'X:\directory\database.mdb' object. Have your system
administrator or the person who created this object
establish the appropiate permissions for you."

I am new to security for Access. Could someone please
explain what I need to?

TIA
Barb

 

[Joan Wild]

Hi Barb,

I created a workgroup file which is located locally on my
hard drive. I set myself as the administrator. Only I
can open the file from the shortcut for the workgroup
file. But the other users cannot open it; The users have a
shortcut to the database itself.

That is why. Your shortcut is more than a shortcut to the workgroup file.
You need to either copy your shortcut to their desktops, or recreate. If
you examine the target, you'll see
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

Giving them a shortcut to just the database will cause it to open using
their default system.mdw, and therefore the error you are getting.

 

[Joan Wild]

Just put the mdw on a network folder. Modify the path in the shortcut to
point to the mdw on the server.

It is easier to manage the mdw if there is only one copy.