Open mde remotely

[J. Shrimp, Jr.]

Have an mde that has a bunch of queries,
one macro ("Autoexec") which runs the
queries.
Would like to compile code in VB/VBA
to simply open the mde file so that Autoexec
runs.
Mde will close itself 'cause the last statement in
the Autoexec macro is "QUIT".
What is the best way to open an mde from
code so I can put the compiled code on
the scheduler, having it run every morning?

 

[Steve Schapel]

J,

If you are aiming to open the MDE using a scheduler, I can't see any
relevance for VB or VBA or whatever. All you need is put the command
line for the scheduler to run, something like...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourFile.mde"

 

[Jim/Chris]

If you are going to use a scheduler why do you need to
create any code. In your scheduler command line use

"Path to Msaccess exe/MsAccess.exe" "Path to MDE/MDEfilename"

example

"c:\program files\microsoft office\office\Msaccess.exe"
"c:\my documents\MyMDE.mde"

Jim