Yeah, the database is big, and My customer really doesn't want his
people to have the kind of access to the data that you describe.
Is there something better to use in the VB program than inet? Or is
there something like myAccess which can be programmed to do only
specific things needing only someone to get it started?
Bj wrote:
You could try something like myAccess ($35, see
http://www.hiden.org/myaccess/ ) which is an addin for Access that
allows you to open and work, live, with online mySQL DBs from your
local PC. There are other programs/addins that work in a similar
way. Some are free.
I have an automated backup system that I wrote for my mySQL databases
which are on a *nix host. It has a php front end for checking and
editing the backup schedule, and uses cron to control when they run.
It uses the mysqldump command that dumps a db to an sql script to
produce a backup file, then saves a copy locally and/or emails a copy
to a specified email address. You can then run that sql script at any
time to recreate the database if required. But this may be more
complex than you need or can support, or your db may be on a Windows
host, or too big (these db's have no more than a few hundred records,
yours sounds large!)
----- Original Message ----- From: "Diane Schips"
<[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, January 02, 2006 3:50 PM
Subject: Re: [wdvltalk] Problem disabling the submit button
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.
____ • 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.
____ • 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: unknown lmsubst tag argument: ''
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.
