Starting MS Access

[Jay Myhre]

The command line I use includes the database name, and wrkgrp. It requires
the user to enter a name and password when opening the database. The problem
is if the user cancels the logon then the MS Access toolbar appears allowing
the user to navigate (file/open) the same as if using Windows Explorer. This
is a problem when the application is on a Citrix server. Any suggestions on
how to have the default Access toolbar not appear if the user doesn't sign in
using their name/password? I'd rather not use the run-time version.

 

[John W. Vinson]

The command line I use includes the database name, and wrkgrp. It requires
the user to enter a name and password when opening the database. The problem
is if the user cancels the logon then the MS Access toolbar appears allowing
the user to navigate (file/open) the same as if using Windows Explorer. This
is a problem when the application is on a Citrix server. Any suggestions on
how to have the default Access toolbar not appear if the user doesn't sign in
using their name/password? I'd rather not use the run-time version.

If you've implemented workgroup security correctly - taking the Admin user out
of the Admins group, revoking all its privileges and/or giving Admin a
nonblank password - they can't do anything with the database anyway. Have you
done so?

John W. Vinson [MVP]

 

[Albert D. Kallal]

Actually, if you do add the /runtime switch to the shortcut, if the user
hits cancel at the logon prompt, then access does shut down....

Any suggestions on
how to have the default Access toolbar not appear if the user doesn't sign
in
using their name/password? I'd rather not use the run-time version.

You don't actually need the runtime, but give the /runtime switch a try in
your startup...it does shut down access for me if you hit cancel on the log
on....

 

[Jay Myhre]

Albert,
Thank you very much. Your respone was exactly what I needed. I
couldn't find the /runtime option in the startup command prompt when I
searched MS Access. You have saved me a lot of time and effort.
Jay Myhre