ODBC access and WANs

[scott]

I've heard that using ODBC to access a MDB file on a file
server across a WAN is bad. We currently have a small
group of users that work with a common MDB file on a LAN,
we are looking to move the MDB to a national file
sharepoint and have users access it across the WAN..
Why is this a bad approach?

Thanks!

 

[Kevin3NF]

Network instability. A DSL, Cable or even T1 connection is going to suffer
more hiccups than your internal 100mbps network, and Access does not handle
this very gracefully.

That, and the fact that HUGE amounts of data are being pulled across the
network when tables and queries are accesed. On the LAN, this is not bad,
but on a WAN it is magnified.

Use a terminal server/Citrix approach instead, which keeps everything on the
LAN, but is available to remote users. I use this setup and it works great.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Albert D. Kallal]

The first problem is how fast is the wan?

Read the following article of mine to advoid some common problmes:

Using a wan with ms-access? How fast, how far?
By Albert D. Kallal
Saturday, August 09, 2003

http://www.attcanada.net/~kallal.msn/Wan/Wans.html