"Henrik Thomsen" wrote
I have got two databases, one with
containing all data - tables, and the
other contains queries, and forms,
reports etc. - I have linked the two.
On a stand alone computer it runs fast.
But putting it on a net (for multiple users).
It become very slow- (if I put all the tables
in the same database as the queries, forms
etc. then it is quick again. But I need to
have two databases, how do I get it to
become quicker? - what is wrong?
The best collection of information and links on Access performance that I
know about is maintained by MVP Tony Toews at
http://www.granite.ab.ca/access/performancefaq.htm.
For an overview of topics I considered worth discussing with members of my
user group, you can download a presentation _Access in a Multiuser
Environment_ from
http://appdevissues.tripod.com/downloads.htm.
Just in general, there are many factors involved in performance. And, the
first thing I usually say is that "a well-designed and well-implemented
single user database does not become a well-designed and well-implemented
multiuser database just by splitting off the tables and relationships and
then giving each user a copy of the front end".
Larry Linson
Microsoft Access MVP