slow access

[Guest]

Hi


I have a database split Front End and Back End the back end is on the server
and only contains the tables. The front ends are on the individual machines
with all forms, queries and reports. My problem is that when more then one
user is using the database at a time it runs very slow, so slow that it can
get annoying waiting for forms to load. Is there a way that this can be
speeded up?

Thanks in advance for any help
Chuck

 

[Albert D.Kallal]

Well, since it performances good with one user, then likely the solution
here is to open a persistent connection.

That means in your startup form, simply open a table to the back end...any
table will do.

Try the above..and your database will likely run *faster* with two users
then when one is in it now!!!

The above trick, and a list of additional things to check can be found here:

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

The "key" issue in your post is that one user runs fast. (so, why then would
things like track autoname correct etc. cause this problem?)

Further, you stated that performance seems fine with one user (again,
looking for a performance issue in your code would be silly, since it runs
fine with 1 user).

Bottoms to dollars....a persistent connection will fix this for you......