If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Slow to link tables over a network
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 |
#2
|
|||
|
|||
Slow to link tables over a network
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/WileyT...764559036.html "Scott M" wrote in message ... 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 |
#3
|
|||
|
|||
Slow to link tables over a network
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/WileyT...764559036.html "Scott M" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Slow tables | ddobos | Tables | 1 | June 17th, 2004 06:41 PM |
Link tables from a secured db | Diarmuid | Using Forms | 4 | June 2nd, 2004 03:23 AM |
Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |
Slow opening of tables. | Frank Martin | Database Design | 3 | May 3rd, 2004 02:27 AM |
Network User Name Link On Forms | wwoodall | Worksheet Functions | 0 | January 14th, 2004 08:06 PM |