icon to a workgroup database 97

[anonymous]

Hi all,
when setting up a workgroup database in access 97, each
time user clicks on access it brings up the logon screen
for my secured database. once you logon then you can
choose a blank database or another database. My question
is how do I make it so it doesn't popup the logon screen
when clicking on the access icon (only when you choose
the secured database)?
Thanks in advance for any help

 

[Graham Mandeno]

Whether or not you get a login screen when you start Access has nothing to
do with the database you are opening, but it is to do with the workgroup
file you are using. The default workgroup file is set by the Workgroup
Administrator application. It seems you have set your default workgroup to
the one for your secured database.

Run the Workgroup Administrator (Start>Run>wrkgadm) and "Join" the original
workgroup file, SYSTEM.MDW. For Access 97, this should be in
C:\Windows(WinNT)\System(32).

Now you will need to make a shortcut to open your secured database. The
Target line for the shortcut will look like this:

"<path to msaccess.exe>" "<path to your database>"
/wrkgrp:"<path to your workgroup file>"

For example:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\Data\My Database\MyDB.mdb"
/wrkgrp:"C:\Data\My Database\MyWorkgroup.mdw"