Sync Local DB across multiple locations over web "epoh97 via AccessMonster.com" <u23316[ at ]uwe> 24.07.2006 15:01:03 What would be the best method of syncing a database, that is stored locally on three computers, that are not connected by a network, but by the Internet only. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200607/1

Re: Sync Local DB across multiple locations over web Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 24.07.2006 15:25:03 hi, epoh97 via AccessMonster.com wrote: [Quoted Text] > What would be the best method of syncing a database, that is stored locally > on three computers, that are not connected by a network, but by the Internet > only. This depends on your concrete needs, but using a VPN and Access replication should do it. mfG --> stefan <--

Re: Sync Local DB across multiple locations over web "epoh97 via AccessMonster.com" <u23316[ at ]uwe> 24.07.2006 15:59:50 Hhmm, there is no VPN. Any other methods? Could I use XML on a website as the datasource for the Access database? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200607/1

Re: Sync Local DB across multiple locations over web "epoh97 via AccessMonster.com" <u23316[ at ]uwe> 24.07.2006 16:05:40 Or could I post the mdb on a website and let that be the shared datasource -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200607/1

Re: Sync Local DB across multiple locations over web Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 24.07.2006 16:10:47 hi, epoh97 via AccessMonster.com wrote: [Quoted Text] > Or could I post the mdb on a website and let that be the shared datasource No. mfG --> stefan <--

Re: Sync Local DB across multiple locations over web Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 24.07.2006 16:11:37 hi, epoh97 via AccessMonster.com wrote: [Quoted Text] > Hhmm, there is no VPN. Any other methods? Could I use XML on a website as the > datasource for the Access database? Yes, but you have to implement the up-/download yourself. mfG --> stefan <--

Re: Sync Local DB across multiple locations over web Armen Stein <ArmenStein[ at ]R3m00v3Th1s.gmail.com> 06.08.2006 05:40:54 In article <OnTT0tzrGHA.4508[ at ]TK2MSFTNGP04.phx.gbl>, stefan.hoffmann[ at ]explido.de says... [Quoted Text] > hi, > > epoh97 via AccessMonster.com wrote: > > Or could I post the mdb on a website and let that be the shared datasource > No. > > > mfG > --> stefan <-- > I'll elaborate a bit. You can't share an Access database from a web site, because you need to connect directly to a \\server\share location. This is what a VPN would allow you to do. But, Access communicates far too much over the network connection for this to work effectively anyway. You could also have remote users all connect to a Terminal Server host running Access and your application. Search the web for "windows terminal server hosting". I've heard from others that this can work well. -- Armen Stein Microsoft Access MVP www.JStreetTech.com

Re: Sync Local DB across multiple locations over web "epoh97 via AccessMonster.com" <u23316[ at ]uwe> 07.08.2006 15:47:52 Hmm, VPN is not really an option for me, neither is Terminal Services (I admin TS). -- Message posted via http://www.accessmonster.com