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
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.