Slow Network Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

acorn - 24 Oct 2005 23:59 GMT

I have the FE sitting on the various work stations which is linked to the BE
on a peer-to-peer 'Server'. Recently it has become painfully slow to even
open a form. It seems to start as soon as one computer has a form open, than
all the rest of the computers become very slow. Any help in this area will
be greatly appreciated.

Reply to this Message

Fred Boer - 25 Oct 2005 01:00 GMT

Dear acorn:

Take a look here:

http://www.granite.ab.ca/access/performancefaq.htm

LBD locking might be the culprit... Also, if I am not mistaken, autocorrect
could also be fingered...

http://allenbrowne.com/bug-03.html (It is listed among the problems with
this "feature")

HTH
Fred Boer

> I have the FE sitting on the various work stations which is linked to the BE
> on a peer-to-peer 'Server'. Recently it has become painfully slow to even
> open a form. It seems to start as soon as one computer has a form open, than
> all the rest of the computers become very slow. Any help in this area will
> be greatly appreciated.

Reply to this Message

acorn - 26 Oct 2005 21:34 GMT

Fred
When I finally got to the part where "LDB locking which a persistent
recordset connection fixes" the speed increased dramatically no matter how
many users were linked to the BE.

Thanks!
acorn

> Dear acorn:
>
[quoted text clipped - 19 lines]
> will
> > be greatly appreciated.

Reply to this Message