I would like to implement a /cmd "debug" command line switch. I've gotten it to work. My problem is that in debug mode, I would like
to display the db window, etc but the startup properties don't take effect until the next restart.

As such, I am using Shell to launch a new instance of the db. For this, I have to provide the path to Access.exe. I would prefer NOT
to hardcode the path to Access and would like to know how to determine this path.

My environment is Access 2002 on Windows 2000.

Thanks, James

Try

SysCmd(acSysCmdAccessDir)

if you are inside of Access.

--
MichKa

This posting is provided "AS IS" with
no warranties, and confers no rights.

it to work. My problem is that in debug mode, I would like
until the next restart.
have to provide the path to Access.exe. I would prefer NOT