Microsoft Access and WAN

[skeletor]

I've been told that Access is not a good program for a WAN. Is this based on the size of the network or the distance of phone lines? I'm working with a program that has a back end residing on a server at a remote location. The back end holds five tables with approximately 3-4 mb of data. There are at most 8 - 10 users and the distances over phone lines can be up to 100 miles. Will I run into problems using Microsoft Access with this setup.

 

[demoman]

Our company has several Access, SQL Server and Pervasive SQL apps, running on a LAN. SQL Server runs great! Pervasive is an absolute dog (we have to run it in a terminal session) and Access is somewhere in between. We are using dedicated T1 connections, with 18 data lines.

All in all, I would not recommend Access for anything mission critical. It is pretty slow. One good thing about Access, you can usually try it out, without a lot of development cost. See if it works OK. If not, consider running it in a terminal session. Works great there.

 

[epoirier]

I think is possible but, very hard programmation. You Need to identify each record is Update to not send All Record (Limit the Download or Upload) Only the new or Modify, Delete Record.

You can't send the data in Text delimited with a program Access or VB is installed on each server The Program Need to check on each hours, days the New Data, Modify or Delete ? depend what you need.

I Never try this but i think is possible.

Let met know if you find something.


Eric Poirier