Syncronize 2 databases

B

Benmat

Can someone point me in the right direction?

I have 2 databases on the same server. Each has 2 tables that need to be
identical. "The 2 tables are called agentInfo and officeInfo. One of the
databases gets updated throughout the day and I would like to automatically
update the other database once each night. I was hoping to use a windows
scheduled Task with maybe a macro. I am using a w200 server and Access 2003.

Any suggestions?

Thanks!

Ben
 
Top