Problem Context
I’ve got a problem with an ASP page that queries an Access database. I’m very inexperienced with Access and ASP so my problem might be quite trivial.

I am developing an ASP search page for a library database. The page will only be used infrequently within a small company, so limitations on the number of concurrent users with MS Access shouldn’t be an issue. Additionally, for various reasons beyond my control, I need to stay with MS Access.

As a side note, this page will only be used internally at a small company so security is not of much concern.

Problem
My ASP page works fine only when I use it from my computer (I’m hosting it on my machine). When I try to use the page from another computer, just-in-time debugging throws up the following error message:

An exception of type ‘Microsoft JET Database Engine: The Microsoft Jet database engine cannot open the file ‘C:\Inetpub\wwwroot\searchengine\search\library. mdb’. It is already open exclusively by another user, or you need its data.’ was not handled.

While I’m pretty ignorant of what’s going on, I’m not stupid. So, I’ve tried giving read/write share permissions to the directory \search so that the user would have the ability to create the .LDB locking file (http://aspalliance.com/14#permissions). I also tried playing around with the Tools>Security>User and Group Permissions. But not really knowing what I was doing, I just tried different things without success.

Code (line of code at which execution stops at is in red):
strDBPath = Server.MapPath("library.mdb")

Set cnnSearch = Server.CreateObject("ADODB.Connection")
cnnSearch.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";"

(some code here... define strSQL)

Set rstSearch = cnnSearch.Execute(strSQL)
rstSearch.Close
Set rstSearch.ActiveConnection = Nothing
Set rstSearch = Nothing
cnnSearch.Close
Set cnnSearch = Nothing

What Next?
Any ideas what I need to do in order to get this working? Thanks!

Well, the problem is, if there is an .ldb file, that is what generates the lock; you are trying to connect to the Access database that is on the same machine as the database, right? What is generating the ldb on the server?

Brian

I'll try to clarify things a little. I believe that there is a .ldb file creating the lock (based upon reading http://aspalliance.com/14#permissions), but I haven't checked this for myself. The Access database is on the same machine as the webserver. I'm not sure, but I think this answers your follow-up question? Thanks.

Rusty