Have you checked out using MSDE with an Access frontend yet? Some of the promotional gibberish from MS suggests your scenario may be a perfect fit. You might also check out this article for some insight on using it:
http://www.devx.com/premier/mgznarch/entdev/2000/05may00/pl0500/pl0500.asp Ken -----Original Message----- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 7:31 PM To: CF-Talk Subject: Synchronizing data Well, here is a bit of an interesting pickle and wonder if anyone has any pointers or even an app to buy to cover something like this: Client has big SQL database and CF solution we are finishing... one employee works on laptop working this system...wants to download database to his local Access database to his local mini-system on his laptop for offline work (Win98/Apache/CF Express/Access), plug back into the network, and synchronize the main SQL database from his offline Access database. Any good way to synchronize this data? Obviously there will be new data in the live system as others are working on it, but his new data and any changed data must be uploaded...this seems to be frought with potential issues. Thoughts? Eric J Hoffman Director of Internet Development Small Dog Design, LLC www.smalldogdesign.com Home of MN Vikings Fans Worldwide! www.purplepride.org ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
