A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Extremely slow connection to linked tables



 
 
Thread Tools Display Modes
  #1  
Old February 14th, 2005, 06:01 PM
annonymous
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.