By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Linking two databases on a net

P: n/a
Hi NG

I have another problem - here it is:

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?

thanks in advance
Henrik

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.