Read-Only

[Bryon]

Hello,

Is there a "read-only recommended" opion hidden somewhere in Access?

If not, is there a way to determine if the database is open in read only
mode in VBA? By this, I do not mean the file attribute, but the /ro
commandline option, so GetAttr won't work.

Thanks.

 

[Van T. Dinh]

Yes, there is a /Ro switch in the MSAccess.exe command-line.

Check Access Help on "Command-line Options".

 

[Bryon]

Thanks, but I already know about that option (I actually mentioned it in my
post). However, changing every user's Windows file associations for MDB to
include /ro is not feasible.

 

[Van T. Dinh]

Your network people should be able to use the LogIn script to place a icon
with the command

{PathToMSAccess.exe} {PathToDatabase} /Ro

on the user's Desktop.