If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I schedule a macro to a make table to run during the nigh.
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? |
#2
|
|||
|
|||
Use Windows scheduler???
"Jeannethe" wrote in message ... 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? |
#3
|
|||
|
|||
.... with a macro in the Access Command Line. Check this in Help.
-- Duane Hookom MS Access MVP "Bill Edwards" wrote in message ... Use Windows scheduler??? "Jeannethe" wrote in message ... 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? |
#4
|
|||
|
|||
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 "Duane Hookom" wrote: .... with a macro in the Access Command Line. Check this in Help. -- Duane Hookom MS Access MVP "Bill Edwards" wrote in message ... Use Windows scheduler??? "Jeannethe" wrote in message ... 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? |
#5
|
|||
|
|||
You probably need to set warnings off prior to running the make table
queries. -- Duane Hookom MS Access MVP "Jeannethe" wrote in message ... 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 "Duane Hookom" wrote: .... with a macro in the Access Command Line. Check this in Help. -- Duane Hookom MS Access MVP "Bill Edwards" wrote in message ... Use Windows scheduler??? "Jeannethe" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Macro to extend a pivot table range | Debra Dalgleish | General Discussion | 1 | July 29th, 2004 11:56 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
My Schedule: Am I dreaming? | JEM | Links and Linking | 2 | May 22nd, 2004 02:53 AM |