Open Another Database in Read Only Mode

[KSReynolds]

Does anyone know the code to launch another access application (2000) from within an existing application in the read only mode? This is my current code that opens the database with all permissions.

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

 

[KSReynolds]

Got it!

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

 

[muckshifter]

well done!