Database security vs. Server Access

[lrfcbabe]

It is obvious that Server access rights take precident over database security. I have two groups set up on the server, read-write and read-only. This line "Set DB1 = Workspaces(0).OpenDatabase(DbName)" works fine for the read-write group, but refuses to work for the read-only group.
The database does not have a password, only the server is controlling access, and of course the app. itself has built-in security. How do I get the server to open the database for the read-only group? P.S. The code is compiled on Win 2K w/Office 97. The read-only group is Win 2k also but some are Office 97 and some are Office 2002.

 

[oharab]

When you open an access database a small ldb file is written to the server to help with record locking etc.
If your users cannot write that file to the server, they can't get in the database.
However,
if the database is opened as read only, then the ldb file is not created. To open it read only, either select the option on the file open box, or put it into a shortcut

C:\program files\Microsoft Office\Office\MSAccess.exe c:\Databases\database.mdb /ro /wrkgrp C:\Databases\db.mdw /user username

will start your database as read only, using the db.mdw workgroup and will automatically put "username" in the username of the dialog.


HTH

Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[lrfcbabe]

So this will open in Access or will it open for the application? I am trying to get the application we are using to open the database.