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:
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,
Patrick
