[MS_AccessPros] Database performance with more than 1 concurrent user

 

Hi,
I have a database used by about 6 people, usually there are only 2-3 in it at a time, but for some reason if there is more than one person in it, certain tasks go from about 30-40 seconds, to 10-15 minutes. Or from 50 minutes to 90 minutes.

Could this be a record lock setting somewhere? I don't understand why there is such a speed discrepancy, particularly when the tasks being run are not writing to shared tables.

Thanks
-Lee

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___