how do you update linked tabels in access on a scheduled bases

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

Guest

I am looking to update linked tables in access on a scheduled bases say every
night. So i would like to know if this is possible through access with some
kind or scheduled run command
 
Mark

We may not be using the same definitions.

In Access, a "linked" table is just that, an open link to a table stored
somewhere else. You wouldn't need to update it because it is always looking
at the data in that other table.

Do you mean you want to download data from another table, into a table that
is local to your Access .mdb file? If so, is this a total replacement, or
an incremental update?

More info, please...

Jeff Boyce
Microsoft Office/Access MVP
 
I am looking to update linked tables in access on a scheduled bases say every
night. So i would like to know if this is possible through access with some
kind or scheduled run command
Click to expand...

Where is the update information to come from? What is the actual
"update" process?

John W. Vinson[MVP]
 

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

Is it possible to Auto Close an Access db at a scheduled time? 6
Shutting Access with a scheduled task 1
Access Access, Error Due to Versioning Differences 0
Review Schedule Database 6
start access from task scheduler? 3
as records added(jobs sched)-#days from est. days 5
middleware, automating Access from "scheduler" 5
Is it possible to run Access Database at a pre-set time? 3

Back
Top