Error opening MS Access from ASP

[vituja]

Hi,

Any idea of what may be causing this other than the obvious. The file is not opened by anyone.

Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file '\\cu-master\depts\IT\Common\Helpstar\HSW.MDB'. It is already opened exclusively by another user, or you need permission to view its data.

/FogBUGZ/FogBugzDailyUploadFromHelpStar/ClosedHistoryUpload.asp, line 21


Here is the Code I use:

dim connectionstring, rs, db, Querystring
connectionstring = "provider=microsoft.jet.oledb.4.0;data source=\\cu-master\depts\IT\Common\Helpstar\HSW.MDB;persist security info=false"
Querystring = "AllHistoryReqForAppDev"


ANY HELP WOULD BE GREATLY APPRECIATED. THANKS.
set db = Server.CreateObject("ADODB.Connection&quot
db.Open connectionstring
Set rs = Server.CreateObject("ADODB.Recordset&quot
rs.Open Querystring, db, 3, 3

 

[YNOTU]

Check this article

http://aspfaq.com/show.asp?id=2009

by

http://www.aspfaq.com

[tt]

​

​