I'll note that many of those hassles with SQL 2000 replication have been addressed in SQL 2005. :-)
Also, it seems you have two broad choices: you could build it as a CFML app, where as Mischa mentions you could store the data in SQL Server. Sadly, CF won't let you license CF for desktops/laptops/tablets cheaply at all, but New Atlanta will with BlueDragon. Then you'd need desktop versions of the database, and in 2005 SQL Server is called SQL Server Express and is indeed free. As always, check MS licensing for more. I'm sure MySQL can help as well. The other broad approach is to instead use Flex/Flash. I know in pre-flex days a Flash app could store data locally in "local shared objects", which were like super cookies. I assume that still exists in Flex, and then you could use another Flex/Flash app to sync that to the server. Oh, just saw Precia's note about Apollo. Down the road, that's certainly another (and likely easier) option. /charlie http://www.carehart.org/blog/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mischa Uppelschoten ext 10 Sent: Monday, October 02, 2006 1:04 PM To: Web Site Subject: re: [ACFUG Discuss] New user & question Hi Max, welcome to the group! I did something like that many moons ago. It used SQL Server 2000 Desktop Edition on the client, which used SQL native replication to a server. Lots of headaches IIRC especially for schema changes. If you want to go this route, start small, maybe two or three clients and use it for a while. Also, I would suggest to use a database's native replication techniques and not reinvent the wheel. Hope that helps. /m > All, Just joined the user group today. I have been a CF developer since 2000. I need to find out if anyone had built or knows how to build an online/offline application. Something like a thin client that the user installs. When working offline the data is saved locally and then synced when the user is online again. Thanks! -Max ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- < Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone: (404) 605-0100 ext. 10 Fax: (404) 355-7930 Web: www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------