Poor multiuser performance

[psperry2]

This system was originally written in Access 2000, but now is run from Access 2003. When only one person is in it, Performance is very good.

When the second person uses it, everything works but very slowly. When a 3rd person logs in, the system is too slow to actually use.

The data is stored in a separate MDB on a network machine and the application is stored in a directory under Program files on the local C: drive. This is true for every user.

I have no idea where to begin, or if this problem is fixable. Can anyone give me a clue as to what to try?

 

[PHV]

Uncheck all autocorrect features in the General tab of the options dialog:
menu Tools -> Options ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Ed2020]

A couple of other things I have found to help:

1. Maintain a persistent connection to the backend (either with a bound form permanently open or by declaring/initialising a global database object).

2. Make sure linked tables are not linked using a DFS file path. Use a UNC filepath instead (\\ServerName\Directory not Y:\DFS_Server\ServerName\Directory).

Implementing these two changes into my systems had a *dramatic* effect on performance.

Ed Metcalfe.

Please do not feed the trolls.....

 

[psperry2]

Ed2020 I checked and the system was designed correctly and I have both a persistant connection ansd UNC paths in the linked tables.

PHV I checked and my development machine was defaulted with 2 Autocorrect options selected. I turned those off. Then I went to user machines and could not get to the menu where I could select Tools --> Options --> general.

The menu had been turned off on those computers and I don't know how to get it back on.

 

[Ed2020]

I think the Name Autocorrect options are set on the database, not on each user's machine.

Ed Metcalfe.

Please do not feed the trolls.....

 

[SeeThru]

Also, check if you AV software (on all machines, especially the 'server' allows you to EXLCUDE MDB and LDB files from scanning.

I use AVG now, but I remember MacAfee caused huge problems after one automatic update.

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk

 

[PHV]

The menu had been turned off on those computers and I don't know how to get it back on.
Open the DB with the shift key depressed.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886