O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Command-Line Options to Open a Shared Database

Access provides a number of options that you can employ to customize how Access starts for each user. All users in a workgroup may share a common database, but you may want individual users to start Access with a different form. You can open a workgroup database automatically, execute a macro that opens a specific form, and supply a user name or password when you start Access by entering options on the command line that you use to start Access for each workgroup member, as in the following example:

d:\msa_path\msaccess.exe [n:\mdb_path\mdb_name.mdb]
 [/User user_name ][/Pwd pass_word ][/X macro_name]
 [/Ro ][/Excl ] [{/Profile user_profile|/Ini profile.ini}] [/Repair] [/Nostartup] [/Compact ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required