The database has been placed in a state by user 'Admin' on machine 'xyzusername' that prevents it being opened or locked RRS feed

  • Question

  • My application installed 250+ systems but the database(single) is shared in server machine. Which have every user read/write permission. some time I'm getting the above error from some systems.My purpose is collecting information from client systems and saving those information in server database. My database is Access Database. Someone guide me pls.
    Wednesday, September 9, 2015 9:54 AM


  • Hi Sarath,

    The error message indicates the access database has reached the max connections or has been locked by clients. In this scenario, access is not suitable for system has lots of clients. I would recommend use Sql Server or other database system in server machine.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Sarath Jasrin Thursday, September 10, 2015 5:54 AM
    Thursday, September 10, 2015 5:49 AM