Slow to link tables over a network

  • Thread starter Thread starter Scott M
  • Start date Start date
S

Scott M

Why is is so slow to link tables to over a network? Straight Access MDB
linking to another Access MDB. If linking to local hard drive it links real
fast! I've noticed some networks (very few) link real fast - usually
Novell. Is there some network transport service that controls this?

Environment is Windows 2000 Server, Windows 2000 workstations, Access 2000.
Basically a 2000 environment. Network is switched at 100MB.

Any suggestion is great appreciated.

Scott
 
Scott,

If you're linking multiple tables, then after you've linked the first one,
open a recordset to it and leave it open until you've finished linking the
remaining tables.

This prevents Access from attempting to delete the LDB file, which it wants
to do after every RefreshLink or TableDefs.Append operation.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top