Question Opening an Access Database in Code as Read Only

[KSReynolds]

I am trying to open up an Access database as read-only from another running Access database. The code I have to open the database currently reads:

"""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"" ""f:\common\patty\Training Database.mdb", 1)

How do I change to read only?

 

[MarkK]

What do you need to do once you have it open?

 

[KSReynolds]

The users need to be able to view the data.

 

[KSReynolds]

Got it!

Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"" /ro ""f:\common\patty\Training Database.mdb", 1)