Ok. I have a database that I wish to display on the Web via ASP and the table is linked to another table in another Access database. I keep getting an invalid path error when I try to connect. What could be the problem?
Printable View
Ok. I have a database that I wish to display on the Web via ASP and the table is linked to another table in another Access database. I keep getting an invalid path error when I try to connect. What could be the problem?
post some code and what do you mean by table, the db table?
If it works fine thru Access, my first guess would be a file security issue.
Ok. I have a table called Resources located in an Access database called CBPTP.mdb. This table is linked to another table in another Access database called CBPTD1.mdb. When I try to run it, it says that CBPTD1.mdb cannot be found. Here is my code for the connection:
That is my connection code which is a SSI.Code:<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4 & _
"Data Source= C:\Inetpub\wwwroot\Lorna\CBPTP.mdb"
%>
Then here is the page I wish to display it in:
See what you can come up with man. I have no idea why this won't work.Code:<!--#INCLUDE FILE="Connection.asp"-->
<HTML>
<HEAD>
<TITLE>Programmer List</TITLE>
</HEAD>
<BODY>
<%
Dim rsProg, strSQL
Set rsProg = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM Resources ORDER BY EmployeeID;"
rsProg.Open strSQL, objConn
%>
<TABLE BORDER=1>
<TR>
<TH>Name</TH><TH>Beeper Number</TH><TH>Employee ID</TH><TH>Extension</TH><TH>Email Name</TH>
</TR>
<%
Do While Not rsProg.EOF
Response.Write _
"<TR>" & _
" <TD><A HREF=resourcemaint.asp?EmpID=" & rsProg("EmployeeID") & ">" & rsProg("LastName") & ", " & rsProg("FirstName") & "</TD>" & _
" <TD>" & rsProg("BeeperNumber") & "</TD>" & _
" <TD>" & rsProg("EmployeeID") & "</TD>" & _
" <TD>" & rsProg("Extension") & "</TD>" & _
" <TD>" & rsProg("EmailName") & "</TD></TR>"
Loop
%>
</TABLE>
</BODY>
</HTML>
I checked the security. Everything is fine. It is connecting to the CBPTP.mdb database but when it goes to the linked table it comes up with that error.