Cannot access secured database

  • Thread starter Thread starter Barb
  • Start date Start date
B

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
 
Hi Barb,

Barb said:
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.
Click to expand...

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.
 
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.
 
Back
Top