Read-Only

  • Thread starter Thread starter Bryon
  • Start date Start date
B

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.
 
Yes, there is a /Ro switch in the MSAccess.exe command-line.

Check Access Help on "Command-line Options".
 
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.
 
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.
 
Back
Top