C
chris
You need to do some tests to localize the problem.
First move the data source to your local machine, relink
the tables and try that.
Then, delete the links, and import the tables, so that
they are all in one database and try that.
If it is still slow, you will need to look at your overall
design, indexing etc.
example, about 15 seconds to open some forms and the same
to save a record and to to a new one).
server.
be independent of the number of users in the Access
application. The Access application (forms, queries,
reports) resides on each PC, and data is accessed through
a link (via a mapped drive) to a second Access file that
contains all the tables in a common location.
to have anywhere near the degree of performance loss that
Access does, I have been unable to establish any firm
correlation with any network degradation.
First move the data source to your local machine, relink
the tables and try that.
Then, delete the links, and import the tables, so that
they are all in one database and try that.
If it is still slow, you will need to look at your overall
design, indexing etc.
opening forms and moving between records in Access (for
example, about 15 seconds to open some forms and the same
to save a record and to to a new one).
Server running Active Directory. Data file resides on the
server.
mixture of Windows 98 & XP Pro PC's. The slowdown seems to
be independent of the number of users in the Access
application. The Access application (forms, queries,
reports) resides on each PC, and data is accessed through
a link (via a mapped drive) to a second Access file that
contains all the tables in a common location.
mostly it is pretty slow. Because no other programs seem
to have anywhere near the degree of performance loss that
Access does, I have been unable to establish any firm
correlation with any network degradation.