Could not use ''; file already in use. AAHRG!

[visualsander]

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

[vbNeo]

Source=\\MyServer\wwwroot\prjGuru\guestbook.mdb;"

Change that to:
Source=\\MyServer\wwwroot\prjGuru\guestbook.mdb"


Just a guess - try it out ..

[visualsander]

Nah, thnx for the try anyway!