Thanks.  My goal is to write the code in VBScript and run it as an ASP
page that is part of my site admin.  So I can just go to the page,
click on "backup DB" and it will return a downloadable Access DB file.

I wrote a quick & dirty script that simply creates a copy of a blank
access DB, then opens each table in the SQL db and copies all of the
data to the access DB.  Then it gives me a link to download the DB
file.

While this works, the code internally just does a "SELECT *" from all
of the tables in the database and then copies everything into the
Access DB in a DO/LOOP.

I can't seem to find any sample DTS code to use and I've read in
various messages that it's a better/faster way to go.

-----------------------------------------------Reply-----------------------------------------------