Linked table refresh causing problems

[Beth]

Hello,
I have a main database that links to a backend database for about 12 tables.
The location of the backend changes periodically, so I have added a command
button with code so that the user can choose the path to the new location,
click the button and the code re-links to each of the tables.
It works, but it is incredibly slow. If I am linking to a new location on
the local computer it takes about 3-4 seconds. When I try to link to a
location on the network, it takes about 3-4 minutes. I checked the CPU
usage and network utilization while the re-link is running and neither goes
above 15%.


Can anyone give me any suggestions?

An a similar note, once the program links to the files over the network,
running a find command is also exceptionally slow.

Thanks,
Beth

 

[Eric Schittlipz]

Hello,
I have a main database that links to a backend database for about 12
tables.
The location of the backend changes periodically, so I have added a
command
button with code so that the user can choose the path to the new location,
click the button and the code re-links to each of the tables.
It works, but it is incredibly slow. If I am linking to a new location on
the local computer it takes about 3-4 seconds. When I try to link to a
location on the network, it takes about 3-4 minutes. I checked the CPU
usage and network utilization while the re-link is running and neither
goes
above 15%.


Can anyone give me any suggestions?

An a similar note, once the program links to the files over the network,
running a find command is also exceptionally slow.

Thanks,
Beth

Try changing the code so it no longer refreshes existing linked tables, but
simply deletes them all and re-creates them from scratch. The code is no
more complex and in my experience this can speed this up considerably.