How can I schedule a macro to a make table to run during the nigh.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeannethe - 20 Jan 2005 18:55 GMT

I use an ODBC connection to gather my data but it is too slow. I have used a
query to make a table instead but I need that data refresh during the night.
How can I automate this process?

Reply to this Message

Bill Edwards - 21 Jan 2005 04:14 GMT

Use Windows scheduler???

>I use an ODBC connection to gather my data but it is too slow. I have used
>a
> query to make a table instead but I need that data refresh during the
> night.
> How can I automate this process?

Reply to this Message

Duane Hookom - 21 Jan 2005 04:43 GMT

... with a macro in the Access Command Line. Check this in Help.

Signature

Duane Hookom
MS Access MVP

> Use Windows scheduler???
>
[quoted text clipped - 3 lines]
>> night.
>> How can I automate this process?

Reply to this Message

Jeannethe - 27 Jan 2005 21:57 GMT

I got the command figured out but the macro is set to run 5 make table
queries and it does not run. I tried other macros and they worked fine. Is
it because the make a table query prompts when deleting the tables? If so How
can I disable that "feature"?
Thanks, JM

> .... with a macro in the Access Command Line. Check this in Help.
>
[quoted text clipped - 5 lines]
> >> night.
> >> How can I automate this process?

Reply to this Message

Duane Hookom - 28 Jan 2005 02:32 GMT

You probably need to set warnings off prior to running the make table
queries.

Signature

Duane Hookom
MS Access MVP

>I got the command figured out but the macro is set to run 5 make table
> queries and it does not run. I tried other macros and they worked fine.
[quoted text clipped - 13 lines]
>> >> night.
>> >> How can I automate this process?

Reply to this Message