473,325 Members | 2,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Link Tables problem....Way too slow to operate.

Hi,

We have an internal network of 3 users.
Myself & one other currently have individual copies of the front-end
MS Access forms and via our individual ODBC links we have used the:

File > Get External Data > Link Tables > select ODBC Databases
facility to link to our back-end MySQL Server. On both our machines
the tables appear in the window very quickly and if we hit 'Select
All', all the tables start loading really quickly into our front-ends.
This works perfectly.

The problem is that with the 3rd user, the Import facility works, but
each table takes about 30 seconds to link in and then eventually when
you try to run the app on their machine, it is so slow you just cannot
use it.

I just upgraded their MS Access to XP but this made no difference.
Their PC is very new and also loaded with windows.

Is there a fix for this as I need them to use this program, but I just
cannot fix it.

Appreciate your thoughts.
David
Nov 13 '05 #1
2 3324
"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...
Hi,

We have an internal network of 3 users.
Myself & one other currently have individual copies of the front-end
MS Access forms and via our individual ODBC links we have used the:

File > Get External Data > Link Tables > select ODBC Databases
facility to link to our back-end MySQL Server. On both our machines
the tables appear in the window very quickly and if we hit 'Select
All', all the tables start loading really quickly into our front-ends.
This works perfectly.

The problem is that with the 3rd user, the Import facility works, but
each table takes about 30 seconds to link in and then eventually when
you try to run the app on their machine, it is so slow you just cannot
use it.

I just upgraded their MS Access to XP but this made no difference.
Their PC is very new and also loaded with windows.

Is there a fix for this as I need them to use this program, but I just
cannot fix it.

Appreciate your thoughts.
David

David,
If all the PCs are set up identically, then I would suspect the network
rather than the software. Access is hyper-sensitive to network issues and
problems can sometimes be traced back to the network card installed in the
problem PC.

Try one or more of these ideas, to see if it is a network problem:
1. Swap the slow PC with a PC which is working normally. In other words,
leave the network cards where they are, but swap the network cables. Which
PC is now slow? If the same PC is slow, suspect the card. If the fast PC is
now slow, suspect something further down the network.

2. Swap the network cards between a fast PC and the slow PC. In other words,
use the same network cables, but swap the internal network cards. Does the
slowness travel with the card, or does it stay with the slow PC? If it
follows the card, that card is flakey and should be replaced. If the same PC
is slow, you have a problem with the PC setup somewhere and that will be
very difficult to diagnose in this ng.

HTH
Cheers,
Doug

--
Remove the blots from my address to reply
Nov 13 '05 #2

"Doug Hutcheson" <do*****************@nrm.blot.qld.blot.gov.blot.au > wrote
in message news:4P****************@news.optus.net.au...
"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...
Hi,

We have an internal network of 3 users.
Myself & one other currently have individual copies of the front-end
MS Access forms and via our individual ODBC links we have used the:

File > Get External Data > Link Tables > select ODBC Databases
facility to link to our back-end MySQL Server. On both our machines
the tables appear in the window very quickly and if we hit 'Select
All', all the tables start loading really quickly into our front-ends.
This works perfectly.

The problem is that with the 3rd user, the Import facility works, but
each table takes about 30 seconds to link in and then eventually when
you try to run the app on their machine, it is so slow you just cannot
use it.

I just upgraded their MS Access to XP but this made no difference.
Their PC is very new and also loaded with windows.

Is there a fix for this as I need them to use this program, but I just
cannot fix it.

Appreciate your thoughts.
David

David,
If all the PCs are set up identically, then I would suspect the network
rather than the software. Access is hyper-sensitive to network issues and
problems can sometimes be traced back to the network card installed in the
problem PC.

Try one or more of these ideas, to see if it is a network problem:
1. Swap the slow PC with a PC which is working normally. In other words,
leave the network cards where they are, but swap the network cables. Which
PC is now slow? If the same PC is slow, suspect the card. If the fast PC

is now slow, suspect something further down the network.

2. Swap the network cards between a fast PC and the slow PC. In other words, use the same network cables, but swap the internal network cards. Does the
slowness travel with the card, or does it stay with the slow PC? If it
follows the card, that card is flakey and should be replaced. If the same PC is slow, you have a problem with the PC setup somewhere and that will be
very difficult to diagnose in this ng.

HTH
Cheers,
Doug

--
Remove the blots from my address to reply


David,

Doug probably has you on the right track to diagnosing the problem, but you
might need to check configuration issues. Are all of the systems in the
same domain? Are they all using the same mechanism to resolve the IP
address of the server? Host files the same? DNS server the same?
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Freddie | last post by:
Hi, I posted a while ago for some help with my word finder program, which is now quite a lot faster than I could manage. Thanks to all who helped :) This time, I've written a basic batch...
3
by: David | last post by:
Hi, We a have a small office network of 3 users. Each user has their own copy of an MS Access Front-End which is linked via their own local ODBC connection to our server's MySQL database (Linux...
22
by: Rudy Ray Moore | last post by:
Why is "Visual Studio .net 2003 7.1 c++" so much slower than VS6 at linking? It looks like "Visual Studio .net 2003 7.1 c++" doesn't even do incremental linking! I make one very minor change in...
14
by: Steve McLellan | last post by:
Hi, Sorry to repost, but this is becoming aggravating, and causing me a lot of wasted time. I've got a reasonably large mixed C++ project, and after a number of builds (but not a constant...
3
by: debbie | last post by:
I have an Access 2002 program that I install using Wise. The first thing my program does when a front end is opened is re-link, then it checks the version and if needed upgrades the backend. My...
9
by: Jeff | last post by:
This a little strange. The link in a FE database get corrupted when the BE get compacted, and the FE is not even open. I have checked. The data is fine in the BE. The data is fine in the link...
3
by: UJ | last post by:
I had somebody (who was an idiot) tell me that tables are slow in rendering? That you shouldn't do things like tables inside of tables. Is that true? I think she didn't know what she was...
7
by: Lisa | last post by:
I have an Access 2000 application that uses the following function to re-link my tables when I switch from my Current back end to a Dummy back end. I also use it to refresh my links. Function...
3
by: vbrookie | last post by:
I've recently created a form link from a listbox with proper link criteria. However, I had to change a form's property to 'tune' the slow reactions from linked tables over the network (the OnLoad...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.