A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old January 20th, 2005, 07:55 PM
Jeannethe
external usenet poster
 
Posts: n/a
Default 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  
Old January 21st, 2005, 05:14 AM
Bill Edwards
external usenet poster
 
Posts: n/a
Default

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  
Old January 21st, 2005, 05:43 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

.... 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  
Old January 27th, 2005, 10:57 PM
Jeannethe
external usenet poster
 
Posts: n/a
Default

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  
Old January 28th, 2005, 03:32 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.