first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

VBA PROBLEM; Access 2000: Command Line Parameters Are Ignored; Command() Function Returns Zero-length String

This is an old problem that keeps popping up over the years: Say I enter a semi-colon or /cmd for my shortcut to my office application file as described by KB article 209207 ("ACC2000: How to Use Command-Line Switches in Microsoft Access"). I have consistently neglected to include the full path of the office application since the shortcut is to the application file and not the application.

In the case of Access 2000, this will not work:

\\\\MyShare\\C$\\Folder\\MySQL.adp ;My Command Parameter

However, this will:

"C:\\Program Files\\Microsoft Office\\Office10\\MSACCESS.EXE"
    \\\\MyShare\\C$\\Folder\\MySQL.adp ;My Command Parameter

where, of course the above two lines should be one line.

mod date: 2003-06-07T00:13:20.000Z