Windows Scheduler to trigger import macro

[Andy]

I have a macro that will trigger a .txt file import process which works fine.
It doesn't seem to work assigning a scheduled windows task to a shortcut of
this macro however.

Is this a known problem? The macro is also set to close the database and
compact it and I seem to remember reading that the close function couldn't be
used within a scheduled macro.

Is there anyway around this please as I spend 3 hours a day importing a
500MB file which could start at 4am.... (I can't change the .txt file in
anyway).

Cheers

 

[Gina Whipp]

Andy,

You would need to assign the Windows Schedule to open Access and then have
something within Access that triggers the macro. As for the closing, I know
it can be done VBA so what function are you using in the macro? Quit or
Close?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that will trigger a .txt file import process which works
fine.
It doesn't seem to work assigning a scheduled windows task to a shortcut of
this macro however.

Is this a known problem? The macro is also set to close the database and
compact it and I seem to remember reading that the close function couldn't
be
used within a scheduled macro.

Is there anyway around this please as I spend 3 hours a day importing a
500MB file which could start at 4am.... (I can't change the .txt file in
anyway).

Cheers

 

[Roger Carlson]

In your scheduler, you have to open Access with the /X switch to execute the
macro on opening. Something like this:

"C:\Program Files\Microsoft Office 2003\Office12\MSACCESS.EXE"
"C:\Users\Roger\Documents\Writing\RABlog\SampleDB.mdb" /X Macro1

I've got a more complete explanation on my blog here:

http://rogersaccessblog.blogspot.com/2008/10/access-101-how-do-i-run-process.html
http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-run-process.html