Re: Connect to Access Data from various regional locations

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 11/28/04 

Date: Sun, 28 Nov 2004 21:07:03 +0000

Hi Paul,

It's not practical to use the ordinary front end mdb/back end mdb setup
over a wide area network, so one way or another you're in for
significant work and/or expense. This article by Albert Kallal explains
the issues and outlines the options:
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

On Sun, 28 Nov 2004 11:12:03 -0600, "Paul Proefrock"
<proefrock@NO_heartlandgroup_JUNKMAIL.com> wrote:

>We are a non-profit organization that keeps all our membership info in an
>Access Database. We would like to be able to put the back-end(data) in a
>centralized location and have various users connect, real-time, to update
>their portion. Users are located in Florida, New York, Missouri and Nevada.
>
>We do not have an organization owned server and we buy space for our hosted
>website and email.
>
>We don't want to go to Data Access Pages (certain access functions not
>supported) or ASP, (Non of us are proficient in ASP), at least not yet. I
>understand that Access only likes to connect to data when on a true network.
>
>What various solutions may be available to us? VPN, hosted server, ? ? ?
>Mind you, we are a non-profit so money/cost is an issue.
>
>I would appreciate any ideas on how to accomplish this
>
>Thanks
>
>Paul P
> 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.