By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Access Command Line Arguments

100+
P: 119
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 RunUntilFinished 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?
Feb 23 '09 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,411
This question was split from How to Automate the Running of Multiple Applications (for context).
Feb 23 '09 #2

NeoPa
Expert Mod 15k+
P: 31,411
You may find Access Command Line Options to be a useful resource for this.

Essentially use :
Expand|Select|Wrap|Line Numbers
  1. 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.
Feb 23 '09 #3

100+
P: 119
Awesome...Thanks for your help!
Feb 23 '09 #4

NeoPa
Expert Mod 15k+
P: 31,411
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 :)
Feb 23 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.