backup linked tables to local tables?

N

Nat1

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
 
J

John W. Vinson

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

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]
 

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

Top