Could not use ''; file already in use. AAHRG!
Hi group,
can someone please help me with this one? I'm trying to use the clsSortableTable.inc created by Devin Garlit.
I keep getting the following error when I try to run my asp file:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/prjguru/include/clsSortableTable.inc, line 476
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
Page:
GET /prjguru/table.asp
I'm using:
an Access 2000 mdb
default open mode= Shared
I'm the only user
Here's the code I use:
<!-- #INCLUDE FILE="include/clsSortableTable.inc"-->
<%
dim objST 'for sortable table
dim objConn, strSQL
dim strProvider
Set objConn = server.CreateObject("ADODB.Connection")
strProvider = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=\\MyServer\wwwroot\prjGuru\guestbook.mdb;"
objConn.Open strProvider
strSQL = "select employeeID, firstName, lastName, 'Northwind Traders' as comp_name, notes as comments from employees"
set objST = new clsSortableTable
objST.Connection = objConn
objST.SQL = strSQL
objST.DefaultSort = "lastName"
objST.WriteTable
%>
PLEASE TELL ME WHY I KEEP GETTING THE ERROR: File In Use?!
TIA
VS
