Update table macro

[EvanB]

All,
I have 2 databases, one local, one located on a server. My local database
has tables that I've copied from the server database. I'm trying to write a
macro that will query the server database whenever the local database gets
opened and update the tables in my local database with the information from
the server database.

 

[Jeff Boyce]

Evan

So you want to have two copies of the data, one on the server and one local?
Why (as in "what business need will this meet?")?

As soon as you have two copies, one of them can be wrong!

Could you do what you need to if you merely "linked" to the data on the
server? That way, what you see would ALWAYS be what's on the server...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.