Posted by Patrick A on 11/08/07 22:30

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
> 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

• Next in forum: Index design
• Prev in forum: Re: MS SQL 2000 formatting numeric value to money
• Thread view: Best Way to Synch 2 Tables?

[Reply to this message]