Hi,
I am sorry. How do I create the UDL file? I do not have Visual Studio loaded on my system, so I do not have VB IDE.
Any case I have not opened the MDB file in access. Still it gives that error. Surprisingly, if I open another MDB file and create a test module with following code, it goes through further without any error. That is, within Access I have no problem opening ADO recordset from any other MDB file but I could not open through ASP file.
Any more ideas?
Thanks once again.
>Is there anybody else using the database? Or maybe you have it open in Access?
>
>Try adding "Mode=Share Deny None" to your connection string to make sure you open the MDB in shared mode. Also always close the connection explicitly before your script finishes.
>
>If this does not work try creating your connection string with a UDL file including UID and PWD and after you save it open it with Notepad to copy and paste the correct connection string.
>
>>Hi,
>>
>>I am trying to develop a search page for our website using ASP/Vbscript. I have an Access2000 database which is secured with a username and password. My following code does not work.
>>
>>
>> Dim oConn
>> Dim oRs
>> Dim filePath
>> Dim Index
>> Dim cQueryStr
>> Dim eExpr
>> Dim cSQLStr
>>
>>
>> filePath = [C:\InetPub\wwwroot\oamslite.mdb]
>>
>> Set oConn = Server.CreateObject([ADODB.Connection])
>> oConn.Open [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=] & filePath
>>
>> Set eExpr = Request.form([custid])
>> If eExpr <> [] Then
>> cQueryStr = [custnum = '] & eExpr & [']
>> End If
>>
>> cSQLStr = [Select * from VLCTests]
>> If cQueryStr <> [] Then
>> cSQLStr = cSQLStr & [ WHERE ] & cQueryStr
>> End If
>>
>> Set oRs = oConn.Execute(cSQLStr)
>>
>>
>>Note: In the above code I have replaced all the double quotes with [] characters as this thread did not allow me to post as is.
>>
>>The error I am getting in the browser is 'The Microsoft Jet database engine cannot open the file 'C:\InetPub\wwwroot\OAMSLITE.mdb'. It is already opened exclusively by another user, or you need permission to view its data.'
>>
>>Is the connection string wrong? Or should I use some other method. I tried giving the userid and password something like:
>>
>>oConn.Open 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' & filePath, 'Admin', 'xxx'
>>
>>But still does not work. Any help would be much appreciated.
>>
>>Thanks & regards