Database slows tremendously as soon as there is more than one user

[charlie442]

Hi gurus

I have built an access database, split it putting the back end on our work server, and distributing front end versions of the database to my colleagues. During current testing the performance of this database is reduced significantly as soon as more than one user logs in.

Does anyone have any suggestions what may be causing this. I am no access pro but after a lot of work building this database it is quite a flop to see the poor performance with even two users busy on the database. I need to save my ass here as I have been spending hours preparing this application, to what seems no avail right now.

Help please
Charlie

 

[jdraw]

There are a number of performance tips at this site
http://www.fmsinc.com/microsoftaccess/performance.html

 

[charlie442]

Thanks jdraw

Most helpful