WorkGroup & Multiple Users

  • Thread starter Thread starter Eng_nader
  • Start date Start date
E

Eng_nader

Greetings,

I created a data base using Access 2002 and created a
workgroup file as well to set my users permission and all
that.

This file will be used by many users with different levels
of permissions. The problem is I will store the file in a
shared drive, but when any users access that file from his
pc, Access will read his scurity settings from the default
workgroup file System.mdw but not the workgroup i created
.... so no use of all the security permissions i created :(

I tried the shortcut method, where i added the command
line : /wrkgrp but it didn't work for some reason ...

CAN ANY ONE HELP ... THANK YOU AND I APPRECIATE YOUR
COOPERATION
 
I users are able to even open your database using their default system.mdw,
then you missed a step in securing it. Likely the Admin user still owns
object(s), and/or the Users Group still has permissions to object(s). Did
you use the security wizard?

Once you have it secured properly, you can put the mdw on the server, and
provide a shortcut. The shortcut requires the full path to msaccess.exe as
in,
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
 
Thank You very much,

I just wanted the command line form as your typed it:
("path to msaccess.exe" "path to mdb" /wrkgrp "path to
secure mdw")

because in Access Help it doesn't tell you to put the .exe
path ... but now after trying it your way it's working
100% ...

Thank you sooooooooooooooo much :) ...
 
Well you still have a problem. Although they use your workgroup file by
opening it via the shortcut, if they don't use the shortcut they are using
the standard system.mdw workgroup. You said they could get into your mdb
doing so.

If you secured it properly, they will *only* be able to get in using the
shortcut.
 
Back
Top