To link or not to link - that is the question

[Warren Van Duesbury]

Does the fact that I have a linked table slow an application down?

With 60 concurrent Users, my app at the moment stores all collected data on the local drives and at the end of the day posts it to the main DB on the server. This is to reduce network traffic and improve the speed of the app.

Does the fact that I have a linked table to the server slow the app down even though I don't need to use the table on the server till the end of the day. Should I re-link the table before I post the data or leave the link in?

Any ideas on this are much appreciated.

Warren

 

[Rich@ITTC]

Hi Warren

Please don't do duplicate postings within this Forum. It's confusing for the poor people who are trying to offer help and advice.

Rich Gorvin

 

[Warren Van Duesbury]

Sorry about that, I meant to post it in the tables forum and accidentally posted it here too.