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.
One thing to remember is that most web hosts (at least the hosts I've dealt with) don't allow remote connections to the databases. You can only connect from localhost. So check with your host before spending time or money.
What I did for a client once was set up a script on their server to dump the data to a file and transfer the data to one of my servers. I have enough control over my server that I can allow remote connections and was able to load the data directly to my database. The data was available in case the client's server went down. This was only needed for a couple of months.
For another client I setup a regular data dump on the web server. They setup some sort of automated ftp to transfer the data to their local Windows network once a day.
Sheila http://www.shefen.com/ ____ 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.
