locked
ACCESS 2003 IS LOCKING RRS feed

  • Question

  • User746201200 posted

    Hi,
    We have an web application on a customer server. This application uses access database.
    But database is locking every 2 or 3 months. Web platform is ASP .NET. ISS is 6.0. We controlled all the codes and there is no open connection or other code errors. Customer server administrator controlled it by unlocker program. When application locked, unlocker report shows that;

    Process          Path Locked                                                         PID        Handle    Process Path
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2404      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2492      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2478      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2785      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2795      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2201      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2967      c:\windows\system32\inetsvr\w3wp.exe
    w3wp.exe       D:\WebSites\Apps\PRM\App_Data\PrmLive.ldb       1348       2986      c:\windows\system32\inetsvr\w3wp.exe

    We are trying the application on our server and there is no lock and no error. Our server windows and ISS is 8.0. We can't find where the problem. Can you help us please:(

    Wednesday, November 24, 2010 5:01 AM

Answers

  • User1716267170 posted

    I think another possibility is when another application/thread has opened it, it'll be locked too. Thus, I suggest you to check your code and ensure the file is always closed in time. Thanks.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, November 30, 2010 3:51 AM

All replies

  • User-1659704165 posted

    Hi,

    Not Very Sure Are  Disposing all Connection properly?

    Wednesday, November 24, 2010 5:30 AM
  • User746201200 posted

    Yes. There is no error in codes.
    All database processes are in a class. In this class all connections closed. There is an example;

    oleDbCommand.Connection = Connection;

    try

    {

       oleDbCommand.CommandTimeout = 0;

       oleDbCommand.ExecuteNonQuery();

    }

     

    {

     

    }

    catch (Exception exp)

    {

      throw (exp);

    }

    finally

    {

       oleDbCommand.Connection.Close();

    }

     

    This locking occurs every 2 or 3 months. If there was an error in code, it would occur more frequently. Also this error doesn't occur on our server. What can we do ???

    Wednesday, November 24, 2010 6:15 AM
  • User1716267170 posted

    I think another possibility is when another application/thread has opened it, it'll be locked too. Thus, I suggest you to check your code and ensure the file is always closed in time. Thanks.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, November 30, 2010 3:51 AM