Getting error System resource exceeded

[princydisney]

Hi Everyone,

Our Company is using a vendor developed application, and user license allocation details are stored on an access db. Recently we got an error as below and users were unable to login to application, as licenses could not be delivered.

error: System.Data.OleDb.OleDbException: System resource exceeded

I have checked in many forums, everything leads to multiple connections opened to access db file(may be connections are not properly handled in code). Connected with vendor, but they said its an oledb provider error, and asked to check with Microsoft. Could anyone of you please help on this. we have few more errors which happened on the same day, providing them below:



1. System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
2. System.Data.OleDb.OleDbException: Could not update; currently locked by user 'Admin' on machine 'XXXXX'

Appreciate your help
Thank you!

[CJ_London]

think either your vendor is trying to duck the issue or you are not using the db in the way they intended/anticipated.

although your interpretation of the error is most likely correct, without seeing the code and knowing your setup - number of users/location of back end/front end/type of backend/etc, it is impossible to say what is causing the problem other that it is most likely to be a coding issue.

you have multiple users - so they each have their own copy of the front end? If not and they are sharing it, that could be the reason why you have the problem - the front end has become corrupted and will not be recoverable. In which case the solution is to issue everyone with their own copy of the front end - not the one they are currently sharing, but a copy that is 'untouched' - perhaps the original supplied by the vendor.

Another less likely possibility is the backend db has reached 2gb in size - in which case the solution is to compact and repair it. But I would have expected a different error.