Thanks for all of the help. That makes much more sense to me.

Thank you for the very detailed example. Wow!

using t-sql, where and how would the connection to the access db be? Is there any way you could give me an example? Please believe me, I'm not...

You're not saying insert the data from one sql table directly into its corresponding access table via t-sql....are you? If so, I didn't know you could do that.

SSChampion, the users load the .mdb file into their local Access databases. What they do with it then is their bidness.

The website allows the user to download a zipped .mdb file that was created in ssis and another program that zips it I guess. The .mdb file is all...

Homebrew, thanks for the reply. No, I do mean .mdb file. It's an Access database file. I believe users download the zipped.mdb file and do some analysis...