backup linked tables to local tables?

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

Guest

Hi,

I have an access file with linked tables to an odbc database and I'm looking
for a way to backup these tables to local tables. Is there a vba procedure
that will accomplish this task?

Thanks
 
Hi,

I have an access file with linked tables to an odbc database and I'm looking
for a way to backup these tables to local tables. Is there a vba procedure
that will accomplish this task?

Thanks
Click to expand...

You could write one easily enough - have it run Delete queries to empty the
local tables, followed by Append queries to append the data. If the ODBC
tables are large, though, this really seems the backwards of what you want -
if the data is in SQL/Server or another client server app, that program should
have a backup policy in place already!

John W. Vinson [MVP]
 
Back
Top