A problem with Linked Tables???

**davidgottlieb** · Aug 27th, 2001, 02:02 PM

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?

**sebs** · Aug 27th, 2001, 02:03 PM

post some code and what do you mean by table, the db table?

**JoshT** · Aug 27th, 2001, 02:07 PM

If it works fine thru Access, my first guess would be a file security issue.

**davidgottlieb** · Aug 27th, 2001, 02:07 PM

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:

Code:

<%
  Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4 & _
			   "Data Source= C:\Inetpub\wwwroot\Lorna\CBPTP.mdb"
%>

That is my connection code which is a SSI.
Then here is the page I wish to display it in:

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>

See what you can come up with man. I have no idea why this won't work.

**davidgottlieb** · Aug 27th, 2001, 02:10 PM

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.

Thread: A problem with Linked Tables???

Thread Tools

Display

A problem with Linked Tables???

Posting Permissions