This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Web Development Code Library ASPHandle "File In Use" with Access

Handle "File In Use" with Access

Simple code that can be used to handle exceptions when the database is locked by another user.

<%
' Assumes objCon and strConnection are declared and created

On Error Resume Next
objCon .Open strConnection
If (Err.Number = -2147467259) Then
   Response.Redirect "offline.asp"
End If
On Error Goto 0

%>
Excellence. Our Measure. Our Motto. Our Goal.