locked
ASP Application fails when accessed by multiple users RRS feed

  • Question

  • User-1297253365 posted

    Hello, We have created an ASP application with MS Access as back end. We have implemented this web application on our server machine and accessed the same from on my local machine.

     Our application works fine when only one user accesses it (All insert, update works fine). But when multiple users connect to this application and try to update the database, then application get crashed. As per our knowledge, this is happening because of access database get locked, when one user open it in exclusive mode. Can you please suggest any work around for the same?  

    Please provide your valuable help.

     

    Friday, May 14, 2010 1:09 AM

Answers

  • User-821857111 posted

    Give MODIFY permissions to the NETWORK SERVICE account on the folder that the database is in.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 14, 2010 3:10 AM

All replies

  • User-821857111 posted

    Give MODIFY permissions to the NETWORK SERVICE account on the folder that the database is in.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 14, 2010 3:10 AM
  • User-1243272925 posted

    Hi,

           R u closing the connection after running the sql?  can you please post ur code for the connection.

    Sunday, May 16, 2010 5:15 PM