I need help getting command line parameters working with MS Access mde files.
When I use a batch file to start MS Access using the /cmd switch all works fine when I start the mdb... however, when I compile the program the mde does not work.
The code I execute to read the parameter is:
strCommand=Command()
This is the line I use in the BAT file to start and test the MDB. Everything works fine.
"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "c:\disti-master\database\Inventory_Program.mdb" /cmd start MAT
Once compiled to an MDE I tired adding this line to the BAT file. This line does not work. It does not return an error, it simply does not read the command line parameter.
"c:\disti-master\database\Inventory_Program.mde" /cmd start MAT
I also tried:
"c:\disti-master\database\Inventory_Program.mde" /cmd "start MAT"
Please help by providing me with a way to have access read the command line parameter "start MAT" when the mde is executed.
Thanks
It will resolve to something like: C:\Users\<UserName>\AppDat