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.