No prompt for user name

6 Sep 2007 11:24 AM

John Barnes

Using Access 2003 SP2, XP Pro SP2. Starting Access application with
shortcut: H:\SBSdb_FE\WIAdb.mdb /wrkgrp
\\Famcomse-hda4hr\SBS_Workgroup\SBSdbMDW.mdw

Access frequently fails to prompt me for a user name / password.
Occassionally Access also fails to launch when clicking on shortcut, and task
manager shows msaccess.exe is running. Need to end process in task manager
before Access will open.

Any ideas about why my application doesn't appear to be properly using the
workgroup admin file or staying hung in background?

Thanks.

6 Sep 2007 11:39 AM

Rick Brandt

John Barnes wrote:

> Using Access 2003 SP2, XP Pro SP2. Starting Access application with
> shortcut: H:\SBSdb_FE\WIAdb.mdb /wrkgrp
> \\Famcomse-hda4hr\SBS_Workgroup\SBSdbMDW.mdw
>
> Access frequently fails to prompt me for a user name / password.
> Occassionally Access also fails to launch when clicking on shortcut,
> and task manager shows msaccess.exe is running. Need to end process
> in task manager before Access will open.
>
> Any ideas about why my application doesn't appear to be properly
> using the workgroup admin file or staying hung in background?
>
> Thanks.

Command line switches are for "executables" not for files. Your shortcut needs
to point at MSAccess.exe, not the mdb file you wish to open. The mdb to open is
supplied as an additional command argument...

"path to MSAccess.exe" /wrkgrp "\\Famcomse-hda4hr\SBS_Workgroup\SBSdbMDW.mdw"
"H:\SBSdb_FE\WIAdb.mdb"

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com