Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created an Access DB and secured it with Admin and user accounts on my
secondary D:/ drive. Then I cut and pasted it to My Documents. Now I get the
following error when I try to access:
"you don't have the necassary permissions to use the D:\Data.mdb object.
Have your system admin or the person who created this object establish the
appropriate permissions for you."
What can I do?
 
Tom said:
I created an Access DB and secured it with Admin and user accounts on my
secondary D:/ drive. Then I cut and pasted it to My Documents. Now I get
the
following error when I try to access:
"you don't have the necassary permissions to use the D:\Data.mdb object.
Have your system admin or the person who created this object establish the
appropriate permissions for you."
What can I do?


You need to create a desktop shortcut that points to the secure mdw for use
with your secure mdb.

The target would look like
"Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

The path to the mdw has now changed, so you need to correct that.
 
Hi Joan
I created a desktop shortcut from the *.mdw security file.
Both my *.mdb and *.mdw files are located now on D:\date.mdb and
D:\security.mdw

But I didn't get this part:
"Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
where I can change the path?
 
Tom said:
Hi Joan
I created a desktop shortcut from the *.mdw security file.
Both my *.mdb and *.mdw files are located now on D:\date.mdb and
D:\security.mdw

But I didn't get this part:
"Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
where I can change the path?


Right-click on the shortcut and choose properties. You'll see the target
textbox. That should have:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
You'll need to substitute the paths to those files as they are on your
computer. For example:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "d:\date.mdb"
/wrkgrp "d:\security.mdw"
 
Back
Top