I hope everyone's New Year is off to a good start!

I need to provide a backup solution for a customer for his website's SQL database. He says his people can't handle using ftp to download the files to the desktop. Not that FTP would help for an SQL database, but this gives you an idea of the situation.

I wrote a VB application that uses inet to connect to the SQL database, and copies the data one record at a time to Access databases on the desktop (after first emptying them). This works fine except some records seems to have funky data that causes errors, and the files take forever to download. My customer wants to do a daily download, but it looks like it will take most of a day to do the download! The tables are pretty big!

I s this the best way to do this? My customer would prefer a webpage that does the download, but I've never tried to copy anything to a customer's computer from the web, and wouldn't this still require copying the records into an Access database, this time on the server?

Thanks,
Diane


____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
      Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk

________________  http://www.wdvl.com  _______________________

You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016

Please include the email address which you have been contacted with.

Reply via email to