Simple command line prompt to call MS Access Module?

Yes, sort of.

You can call a macro in the command line when you open Access. The macro
could have the RunCode command which will run a VBA function.

Example:
"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /x MacroName

You can also use an AutoExec macro to automatically run code when you open
the database or place code in the Open event of your startup form to run the
procedures you need.

Another option is to use the /cmd switch on the command line. You can then
use the Command() function in code to extract this information to react as
desired.

--
Wayne Morgan
MS Access MVP


<tonytony24@gmail.com> wrote in message
news:1143129326.369651.205910@i39g2000cwa.googlegr oups.com...[color=blue]
> Hi All:
>
> I was wondering if there's a simple way to call a MS Access Module
> through either
> Command Prompt
> MS Script
> any other way...
>
> Thanks for the response.
>
> I am trying to extract some data out of a table in Access on a
> scheduled basis, I figured the simplest way is to do a simple module,
> have some command to extract the information, then schedule it.
>
> thx again
> tony
>[/color]

about Cyber Information http://aboutcyberinformation.blogspot.com/