RE: [CFTALKTor] Remote Update of Database

[charles arehart]

I'd think you'd want to look at replication of the DB, keeping the local and remote versions synchronized. It's not trivial, and in Access especially it can be problematic. It's worth investigating. Look in the help for Access or any book on it.  You're definitely not alone in needing this solution, so it would be a good CFDJ article or something if you do solve it.   /charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Wednesday, July 10, 2002 10:47 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Remote Update of Database Hello All,   I was wondering if someone could offer a suggestion for a certain task I would like to perform.  I have a client that is running a VB application that creates an Access database.  I then take that database and upload it to the web daily and over write the access database on the web and site gets refreshed.  This was fine when the database was small now I find myself dealing with a 150 - 200 mb database.  Does anyone know of a way that I can insert a record from my local machine to a remote server and validate that the record was indeed updated without checking the website?  This would be a process that I would like have running over night.   Thanks   Mike