Error Accessing Access Database 2

[dlingo]

I'm working on a project in ASP that allows user input on the front-end, takes the users input, and inputs it into a database on the back-end. However, I'm getting errors when accessing the database. The database was created in Access 95 and is located on the server machine.

The error message I get:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened
exclusively by another user, or you need permission to view its data.
/TroubleTicket/SubmitTroubleTicket.asp, line 4

The code associated with this error message:
<%
strConnect = &quot;Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\

http://wwwroot\TroubleTicket\TroubleTicket.mdb

&quot;
set conn = server.CreateObject(&quot;ADODB.Connection&quot
conn.open strConnect
%>

I've set permissions to full-control for all users and the database is not opened anywhere else.

Please advise.

 

[jonscott8]

MTL, it's a permissions issue. Head over to the MSDN and do an exact phrase search for cannot open the file '(unknown)'. Use any of the several returned articles to troubleshoot.

http://search.microsoft.com/us/dev/default.asp

Jon Hawkins

 

[dlingo]

Thanks Jon, but I just figured it out (with a little help). Here's a helpful URL for anyone who runs into the same problem.

http://www.aspfaqs.com/ASPScripts/PrintFAQ.asp?FAQID=115