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

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

John W. Vinson[MVP]
 
Back
Top