Database Not Responding

Pikeboy

New Member
Joined
Dec 17, 2011
Messages
13
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
803
Well you would need to split the DB and each user to have their own front end. Have you done that.?
 

Pikeboy

New Member
Joined
Dec 17, 2011
Messages
13
Admittedly, I did not. I will research that and address. Thanks for your time/feedback.
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,645
Office Version
2013
Platform
Windows
Good to know. Thanks for reporting back. Thanks @welshgasman for the tip.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,184
Messages
5,467,112
Members
406,524
Latest member
pascalschurink

This Week's Hot Topics

Top