linked tables through ODBC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I want to automate refreshing links to a linked ODBC sybase database.

here is my situation.
Currently I link to sybase tables using ODBC.
This is a large national database, so I then run a query to pull out my
local information, which creates a slimmed-down table.
I then use the slim-table for a local database application.

Problem:
each day I have to update my linked table and then run my query to refresh
my slim-table.

Need:
I'd like to automate this task, and have it scheduled to run each morning at
6:00am and 12:30 pm.

The following code (i just got from this newsgroup) looks like it will get
me close to my desired goal. At least close enough to figure some more
things out. But, How can I schedule this whole situation?

thank you,

phill
 
you can open a hidden form, and use it timer event to run your code at
desired time
 
Back
Top