Refresh linked tables

[Roberto Patuelli]

Why the DAO "Refreshlink" method or the equivalent ADOX
procedure becomes incredibly slow if one or more tables in
the target database are opened in a multiuser
envinronment? (on a 100Mb LAN relinking 40 tables takes
about 20 seconds if tables are closed and from 5 to 12
minutes if some table is opened) I cannot add a new
workstation on the database without asking all users to
close all tables??? Thank you for answers

 

[Gina]

Just a guess here but if the tables are opened while you
are trying to link it has to ALSO check for new data that
may be adding at that time which would make it much slower
than if it was just linking.

Kind of like filling a glass with water that when you
blink someone has taken another sip...

Hope that penny worth of guessing helped...

 

[david epsom dot com dot au]

Open a table in the target and leave it open until linking is finished.

Create new links instead of refreshing old ones.

Turn off 'on error resume next': you are probably missing the
relink error that is causing the link to go so slowly.

(david)