-1

I have used MS Access DB 2010 as a BackEnd for the application that i built using C#.NET. I don't have any queries saved in the database, Rather the queries are saved within the application code and runs using OleDB, ODBC connection.

When multiple user use the application they are getting "The database has been placed in a state by user 'Admin' on machine 'XXXXXX' that prevents it from being opened or locked."

I need to resolve this issue. I am looking for suggestion on how to.

The DB is set up to be in Shared mode with the other options set as shareable. And I am aware that Access Db can handle maximum 255 Concurrent connection.

I have a lot of queries running as part of user triggered actions. All the queries are placed in a Try{} Catch{} block. I have opened and closed the connection right away after a query is performed so that the connection is released.

Now if errors are thrown from one try catch, then it recursively throws other errors from other nested try catch blocks.... is that what is locking the DB?

When multiple users use the application they are getting an error as "The database has been placed in a state by user 'Admin' on machine 'XXXXXX' that prevents it from being opened or locked."

June7
  • 19,874
  • 8
  • 24
  • 34
sfkhan
  • 63
  • 10
  • 5
    Googling for that error message gives many links. To avoid us giving you suggestions you have already tried, please list the links you have already read and tried to apply. – mjwills Sep 19 '19 at 01:56
  • Thank you for the reply. – sfkhan Sep 19 '19 at 19:07