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

J

Jeannethe

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?
 
J

Jeannethe

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Table Security in Access 2013 1
connect to Progress SQL92 Driver using VBA 2
Some mail merge fields not pulling into document 2
Query Speed 5
Make Query or Linked Table Read Only 3
replacing a link to a SQL Server table with VBA 0
Can VBA Plug in ODBC password? 2

Top