Ms Access 97 Security

[LondonJohn]

I am a little puzzled regarding Ms Access Security.
When you set up a workgroup the SYSTEM.MDW file stores all the security information.
This then applies to the running of Microsoft Access, not the running of a particular database.
This means that a user with read-only rights to the particular database, cannot modify or design their own databases any more.
The way round it would seem to be to load Access with a different .MDW file, but that will then let them modify any database,
including the database you were securing in the first place.
Am I missing something here ?

Regards

John Buchanan

 

[PaulF]

If you are using the System.mdw file for your security, you should rename that to something else, then recreate a new System.mdw file with Admin as the only user and no passwords.
To use the .mdw file for your database, create a shortcut to that particular database and for the command line you need to identify the path to the exe file for Access and then add a command to use the new security workgroup file

i.e. for a workgroup file named MyWrkgrp located in c:\datafiles
and the Access exe file located in c:\program files\office

"c:\program files\office\msaccess.exe" /wrkgrp "c:\datafiles\MyWrkgrp.mdw"

PaulF

 

[pfenton]

When I entered that(with my own database) in the 'Start in' command line, it rerurned an error message telling me the folder specified was not valid!
What's happening here ?

 

[PaulF]

I'm a little confused, did you place this command line in the TARGET box of the properties for the shortcut, or in the START IN box??

The command line belongs in the TARGET box

PaulF