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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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