security trouble

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

Guest

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

Let me add to Frank's comments. It appears you have all your database
files on the server and sharing it between two or more users. I strongly
suggest you look into splitting the database with only the dynamic data
tables on the server (the back end database) and all the rest of the forms
queries etc. on each user's machine (front ends). However do one thing at
a time, get your security straight first. Be careful and keep everything
backed up.
 
Back
Top