Pass arguments to Access 2000 via command line

Is there any way to pass an argument into an Access MDE application via a command line?
We have a .NET application that needs to shell out to Access and open a form in our own Access 2000 application on a given record, so we need to pass the order# into the form while loading the .MDE app.

One solution, which we do not want to use, is to write out the order# to a temp table and then have the Access app read from that table when it opens because of multi-user issues.

Thanks.



Use /CMD followed by the arguments. Best if it is the last switch used. Within Access, use Command$ to get the arguments passed.

Jim.



Use /CMD followed by the arguments. Best if it is the last switch used. Within Access, use Command$ to get the arguments passed.

Jim.



Here's a couple handy functions. Note that you will need to modify slightly (error handler).

Jim.



Here is a link to the relevant Help entry -
http://support.microsoft.com/en-us/kb/209207

The article omits a salient point and that is how to retrieve the /cmd value. Another source (which must remain nameless) suggested using Command() to retrieve the value that follows /cmd.



Thank you!



Share this

Related Posts

There was an error in this gadget