ACCESS 2003 IS LOCKING

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:(

Answer 1

User-1659704165 posted

Hi,

Not Very Sure Are  Disposing all Connection properly?

Answer 2

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 ???

Answer 3

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.