This is probably pretty simple, but how do I pull information from two different tables on the same page without getting any errors? Thanks for your help!

If you want to combine the data from the 2 tables into 1 recordset you need to look at SQL JOIN syntax.

If you want the data separate you need 2 recordsets.

Can you give more detail? If you have some code at the moment which doesn't work then post it here and we'll take a look :D

rgds
Phil

I actually have one page and wanted to use SSI to include two different files that each pull from a different table. Here are the codes I have for each include page....

Page 1:

<%
Dim adoCon
Dim rsSchoolClosing
Dim strSQL
set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/stacygraff/database/mercy.mdb")
Set rsSchoolClosing = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblSchoolClosing.* FROM tblSchoolClosing;"
rsSchoolClosing.Open strSQL, adoCon

Do While Not rsSchoolClosing.EOF
    Response.Write ("<img src="../images/arrow1.gif" width="31" height="21"> "
    Response.Write (rsSchoolClosing("Description"))
rsSchoolClosing.MoveNext
Loop

rsSchoolClosing.Close
Set rsSchoolClosing = Nothing
Set adoCon = Nothing
%>

Page 2:

  <%
Dim adoCon
Dim rsNews
Dim strSQL2
set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/stacygraff/database/mercy.mdb")
Set rsNews = Server.CreateObject("ADODB.Recordset")
strSQL2 = "SELECT tblNews.* FROM tblNews;"
rsNews.Open strSQL2, adoCon
Response.Write ("<table border=""1"" cellpadding=""5"">")
Do While Not rsNews.EOF
    Response.Write ("<tr>")
    Response.Write ("<td>")
    Response.Write (rsNews("NewsInfo"))
    Response.Write ("</td>")
    Response.Write ("<td>")
    Response.Write ("<a href=""updatenewsform.asp?ID=" & rsNews("NewsID") & """>")
    Response.Write ("Edit")
    Response.Write ("</td>")
    Response.Write ("<td>")
    Response.Write ("<a href=""deletenewsentry.asp?ID=" & rsNews("NewsID") & """>")
    Response.Write ("Delete")
    Response.Write ("</td>")
    Response.Write ("</tr>")

    rsNews.MoveNext
Loop

Response.Write ("</table>")

rsNews.Close
Set rsNews = Nothing
Set adoCon = Nothing
%>

The only thing I can see that might cause you problems is that both include files Dim the same variable "adoCon". What error(s) are you getting?

A couple of other comments about the way you're doing things:
1. you shouldn't use the Access ODBC driver in ASP, you should use the Jet OLEDB driver instead (see here http://www.able-consulting.com/ADO_Conn.htm for connection string examples)
2. why do you do SELECT * for both recordsets when you only need 1 or 2 fields out of each table? It's more efficient to only select the fields you are going to use.

hth
Phil

This is the error I get...

Microsoft VBScript compilation error '800a0411'

Name redefined

/stacygraff/managementarea/Admin/incnews.asp, line 6

Dim adoCon
----^

Yes, you get that error because you are trying to define (Dim) the variable adoCon twice - you need to rename it in either one of your include pages.

That worked! Thank you!