Wouldn't CF need to be installed on the local/Access machine for WDDX to work?
H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -----Original Message----- > From: Richard Meredith-Hardy [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 10:34 AM > To: CF-Talk > Subject: Re: (ot) Access, SQL Server and Replication > > Sounds like a job for WDDX > > I have done something like this where Excel running locally talks to a > web server by WDDX so I don't suppose it would be too difficult to get > Access to do the same. > > > "Owens, Howard" wrote: > > > > I have a client with an ecommerce site (not quite finished yet). > > > > One of the issues is keeping the online inventory in sync with the > in-store > > inventory. > > > > He only has a dial up connection and one phone line, so he doesn't want > to > > be online all of the time. > > > > He does have Access on his computer. > > > > I know the SQL Server client tools have some sort of replication > ability. > > > > What I'm wondering ... and I'm hoping one of the SQL Server guru's here > can > > tell me if it's possible ... Can I use the SQL Server client tools to, > on a > > daily basis, replicate his inventory in-store with the main SQL Server? > And > > is there a way to daily have the two databases talk to each other and > figure > > out which inventories have changed (the in-store database will have > > modifications each day as will the online database). > > > > And to complicate matters further, the client has two store locations > and > > that inventory should be in synch, also. > > > > Just in theory, is this a solvable issue using the tools available? > > > > Howard Owens > > Internet Operations Coordinator > > www.insidevc.com > > [EMAIL PROTECTED] > > AIM: GoCatGo1956 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists