ODBC access and WANs

  • Thread starter Thread starter scott
  • Start date Start date
S

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!
 
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
 
Back
Top