Split Database Very Slow >1 User

K

Karl Burrows

I just split my database into a front and back-end to put on a new server.
For some reason, any time a second person tries to access the data back-end,
access to the data is very slow or freezes the front-end. I double checked
to make sure it is not a network issue and ran it at home on my network and
the same thing happens. Is there something I should look for that would
create this issue? There is a lock on the back-end data side that shows up
anytime a user opens a form in the database. Should this happen with
multi-user access?

Thanks!
 
A

Albert D.Kallal

9 out of 10 times, fast = 1 user, slow after more then 1 means the locking
file is suspect.

Simply keep a persistent connection from the FE to the BE at all times.
(this in plain English simply means that the FE needs to open a table to the
BE, and keep it open. You can do this via opening a form that is bound to a
table in the back end, and then minimize that form, or simply open up a
global recordset in your startup code).

The above restore performance to un-split levels.

The above trick is mentioned in the following faq

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

Karl Burrows

Well, tried the hidden form to create a bound link, so we will see what that
does. I also renamed the backend to just "Data.mdb" and shortened the
folder name the back-end is under trying to troubleshoot as much as I can.

Thanks and look for a follow-up post in a few days! I may need help again!!

9 out of 10 times, fast = 1 user, slow after more then 1 means the locking
file is suspect.

Simply keep a persistent connection from the FE to the BE at all times.
(this in plain English simply means that the FE needs to open a table to the
BE, and keep it open. You can do this via opening a form that is bound to a
table in the back end, and then minimize that form, or simply open up a
global recordset in your startup code).

The above restore performance to un-split levels.

The above trick is mentioned in the following faq

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