One of my applications is using asp.net and MS Access. At times , I m getting the following error: "System resource exceeded.Microsoft JET Database Engine "
Can anyone help to sort this issue.
Easy_Coder
5:47 pm on Apr 19, 2007 (gmt 0)
How many users are you supporting with this application? Access has a concurrent user limit.
dukelips
2:51 pm on Apr 20, 2007 (gmt 0)
not more than 5 at a time
RichTextBox
1:59 am on May 1, 2007 (gmt 0)
1. There's some limit using Access database. Well the best way is to use SQL Server. If you can't try to pack / repair the mdb.
2. Use the latest MDAC
3. It could be caused by other applications running on the same server. Try find a dedicated server and do some tests.
