Since you are using an Access database, and that is a single binary file, you could do a checksum against that file. So, on the local machine, when the file is updated, you create a checksum file (an MD5 file is an example). Then you upload both files and check the binary Access file against the uploaded checksum file. If the Access file was uploaded intact, then the checksum file will match.
Of course, off the top of my head I don't know how you would check the file against a checksum on the server. Perhaps there is some java code somewhere that you could integrate with CF. I suggest this way because it is one of the few benefits of using Access is that it is a binary file. Another way you could do it is like this: Set up CF Server on your local machine. Write a script that opens the database and checks each entry (I would suggest only getting entries that have been modified - assuming you are using a datestamp.) For each entry on the local database that has been changed, connect to the remote database and do an insert / update. Then, using the same CF script, you could re-query both databases, comparing the results against each other. If they are the same, then it worked. This would work whether or not you use Access. I suspect that with a 200 mb database that at some point you would upgrade from using Access to something better. Hope this gives you a few ideas. I am sure that there are many more ways of doing this. James At 10:47 AM 7/10/2002 -0400, you wrote: >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 - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: James Eberhardt <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
