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
|
|||
|
|||
Extremely slow connection to linked tables
I have 3 computers with front end databases where the user can choose a
backend data file that is stored on computer A. If any one of the computers reconnects to the tables it works fine and connects in under 3 seconds. However, if a user is connected to the backend data file on one computer, opens any of the forms, and another computer tries to link to the file, they have to wait up to 10 minutes for the connection. If a third computer joins, it is even slower. I have checked the front end and back end so that it opens shared, with no locking checked. I have also confirmed that the network speed is not an issue. Can anyone tell me what I am overlooking or how to avoid this situation? Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter on query of linked tables | Sunny | Running & Setting Up Queries | 1 | January 7th, 2005 12:45 PM |
VBA: Insert Into-Statement for linked Tables | Sascha Hennig | General Discussion | 10 | January 6th, 2005 01:26 PM |
Hard Code Linked Tables | myelasticmind | General Discussion | 1 | October 1st, 2004 07:46 AM |
Formatting Linked Excel Tables | Tammie | Tables | 7 | June 10th, 2004 10:25 AM |