security trouble

[_]

So I have followed the Step by Step instructions provided and still need
help. The final step creates a shortcut on my desktop.

But I need to create a shortcut on the shared drive (fyi - the .mdw and
database files all are - i put everything on the shared drive) so other users
can access it.

When they open the .mdw security file none of the tables or reports appear
so I know it's not that one to open.

So they try opening the original .mdb database and an error message appears
stating "You do not have the necessary permissions to use the...object..."
Now could it be that my shared drive happens to be L: and others can
have their shared drive R: or whatever the case may be. I am really at a
loss right now as I have been trying to tackle security for over a week!
I've done the step by step and read the document posted on
www.geocites.com/jacksonmacd...please help.

 

[Frank Stepanski]

Hi,

If I'm understanding your question correctly, you have a secure database on
a network (shared drive) and people that are trying to access that database
are getting an "you do not have the neccesary permissions" error?

If that is the case, it has nothing to do with the users permissions to the
shared drive, it has to do wit h the users of that database not using your
secured .mdw. The shorcut that they are using to acces the database must
specify the .mdw that has the security settings for all users of the
database. The .mdw that you used to set the security setting for each user
must also be in the shared drive. So make a copy of that .mdw (search on your
computer for System.mdw) and rename it to security.mdw or something similar
and put it in the shared drive as well. Then in your shortcut that your users
use to access the database specify that security.mdw by: "c:\Program
Files\Microsoft Office\Office\Msaccess.exe"
"\\server\share\Databasename.mdb" /wrkgrp "\\server\sharename\Security.mdw"

Double check the location of the access.exe on your PC since with each new
verions of Access it gets installed in a different location.

That should work.

Frank Stepanski

 

[minh thao]

xin chao