Database Not Responding

[Pikeboy]

I created a database and placed it on a shared network where a typical day sees two users entering data into forms that each update the same table. They have both complained of this taking a long time, errors out, and/or get a "database not responding" message. In researching this I thought I understood this type of activity could support 30-40 users before seeing these types of issues. Am I off with this expectation or is there possibly a common error I have made that is causing this? Any feedback is extremely appreciatiated and thanks in advance.

Rob

 

[welshgasman]

Well you would need to split the DB and each user to have their own front end. Have you done that.?

 

[Pikeboy]

Admittedly, I did not. I will research that and address. Thanks for your time/feedback.

 

[Pikeboy]

I split the database and thus far vast improvement. Thanks for the feedback.

 

[xenou]

Good to know. Thanks for reporting back. Thanks @welshgasman for the tip.