Access Command Line Arguments

[billelev]

Is it possible to start an Access database, using the above code (*** Edit Shell() ***), but also by passing in arguments? I'm pretty sure I've done this before using the Shell command, and given the routine RunUntilFinishe d uses Shell I think I should be able to. I'm not sure what I have to do on the Access side to accept the arguments, however.

Any thoughts?

[NeoPa]

This question was split from How to Automate the Running of Multiple Applications (for context).

[NeoPa]

You may find Access Command Line Options to be a useful resource for this.

Essentially use :

MSAccess.Exe {Database Path&Name} ;Your extra parameters here

The Command() function within the code of Access will give you access to the Your extra parameters here bit.

[billelev]

Awesome...Thank s for your help!

[NeoPa]

No worries.

I realised how fundamental and interesting a question it was (It got my interest) so I dug up what I could on it and now I know how to use it :)