By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,120 Members | 1,799 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,120 IT Pros & Developers. It's quick & easy.

Performance by working with linked tables

P: n/a
Dear reader,

By working with a frond-end and back-end databases with the use of linked
tables the performance, if both mdb's are on a local drive is reasonable.

But in case the backend is located on a network drive the performance is
decreasing drastically.

And in particularly the comboboxes are working very slowly.

By activating a combobox the message pops up "Not responding" and after a
few seconds it disappear and the combobox opens.

Is there any solution to solve this inconvenience behavior of working with
linked tables on a network drive?

Thanks for any help.

Kind regards,

Simon van Beek



Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Fri, 28 Oct 2005 09:49:01 +0200, "S. van Beek" <S.******@HCCnet.nl> wrote:
Dear reader,

By working with a frond-end and back-end databases with the use of linked
tables the performance, if both mdb's are on a local drive is reasonable.

But in case the backend is located on a network drive the performance is
decreasing drastically.

And in particularly the comboboxes are working very slowly.

By activating a combobox the message pops up "Not responding" and after a
few seconds it disappear and the combobox opens.

Is there any solution to solve this inconvenience behavior of working with
linked tables on a network drive?

Thanks for any help.

Kind regards,

Simon van Beek


A network is slower than a hard drive, so accessing data over a network is
slower than accessing data from the hard drive. If a combo box is too slow,
it is selectig too much data. You should modify the application design, so
one combo box will never be used to select that many rows at once.
Nov 13 '05 #2

P: n/a
"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:43*********************@reader1.nntp.hccnet.n l...
Dear reader,

By working with a frond-end and back-end databases with the use of linked
tables the performance, if both mdb's are on a local drive is reasonable.

But in case the backend is located on a network drive the performance is
decreasing drastically.

And in particularly the comboboxes are working very slowly.

By activating a combobox the message pops up "Not responding" and after a
few seconds it disappear and the combobox opens.

Is there any solution to solve this inconvenience behavior of working with
linked tables on a network drive?

Thanks for any help.

Kind regards,

Simon van Beek


Try deleting all the linked tables completely and then re-creating them.
Although simply refreshing the links should work in theory, in practice I
have had more than one situation where network performance was still very
poor after refreshing, but was dramatically improved by the above technique.
I would also recommend this after any backend table changes
Let us know if it helps or not.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.