Best Way to Synch 2 Tables?

All,

I have an Access DB. On a nightly basis, I want to look at an Other
DB (not Access, but SQL) and:

+ Add any new records from Other.Clients into Access.Clients

Quote:

Originally Posted by

Update 9 fields from Other.Clients into Access.Clients where changes have occured in Other.Clients.

Is this something I should use a "tool" (SQL Data Compare, SqlSync,
etc.) to do, or could I pull this off reliably every night just using
SQL from the query I could construct to do the job from inside my
Access DB?

And for question Deux, if I can just use the SQL I will write, what's
the best way to kick off the process at 3:00 am every morning?

Thanks,

PatrickPatrick A (parkins@.stradley.com) writes:

Quote:

Originally Posted by

And for question Deux, if I can just use the SQL I will write, what's
the best way to kick off the process at 3:00 am every morning?

A scheduled job in SQL Server Agent.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx