Slow to link tables over a network

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
 
G

Graham R Seach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slow in saving record in network, multi-user platform. 1
Access application slow over SBS network 2
Access 2007 Slow When Connected to Network 7
Access working slowly on a network 7
slow adp and linked tables 1
Looking to automatically re-link tables in Access 2
SQL Server Backend: linked tables or no more bound forms ? 4
Access 2003, sharing application over a Novell Network 3

Top