troubleshooting Question

ASP Not a Valid Path - Microsoft JET Database Engine error '80004005'

Avatar of Gary Croxford
Gary CroxfordFlag for United Kingdom of Great Britain and Northern Ireland asked on
ASP
2 Comments2 Solutions594 ViewsLast Modified:
Thank you for looking at my question,

I am trying to put together an asp page that lists data from an MS Access database query.

The access database resides in a folder on the server.
I have created a virtual directory that points to the folder in which the database resides and yet, when I load the page to the web browser I get the error message

Microsoft JET Database Engine error '80004005'
'K:\Team Leader\Production Planning\Data\LSA Production.mdb' is not a valid path.

Use the two bits of code below to make the connection:


<%
          strconn_ANOD = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &_
          server.mappath("AnodSched/LSA Production.mdb") & ";"
%>

<%
      Set con = Server.CreateObject("ADODB.Connection")
      con.Open strconn_ANOD, "", ""
%>

The problem I have is that K:\Team Leader\Production Planning\Data\LSA Production.mdb is the correct path to the database file I need to interrogate.

Any and all help gratefully received.

ASKER CERTIFIED SOLUTION
edlunad

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros