Slow!

S

Sam

I have a back-end database which size is around 80mb saved on my server. If
there are more then 5 or 6 users using the front-end database to link to the
back-end database at same time, it becomes very slow when I try to query or
open a form. I think the network is no problem because copy the whole
back-end databese to my workstation is much faster than query the data using
the frond-end database.
Is it possible to make it faster?
Thanks!
 
G

gandafl

probably

you should check out Tony Toews site
http://www.granite.ab.ca/access/

Mostly it is because of:

-autocorrect feature turned on
-having no persistent recordset (avoid recreating ldb file)
-subforms should have name to None instead to Auto

Possible also some indexing will be required
 
Top