Count Records in Multiple Tables 1

[ElEye]

I would like to present the total number of records of 2 MS Access tables on one page. That is to say that I'd like to display 2 response.writes: 1 record count of all records for each table.

How would I go about this?

Thank you in advance! Dave
[

http://flashspot.com

]

 

[baddos]

Set objConn = Server.CreateObject("ADODB.Connection&quot
Set objRS = Server.CreateObject("ADODB.Recordset&quot
objConn.Open "some conn string"
objRS.ActiveConnection = objConn
objRS.Open "SELECT Count(*) FROM table1"
Response.Write "Table1 has "& objRS.Fields(0).Value &" record(s)"
objRS.Close
objRS.Open "SELECT Count(*) FROM table2"
Response.Write "Table2 has "& objRS.Fields(0).Value &" record(s)"
objRS.Close
objConn.Close
Set objRS = Nothing
Set objConn = Nothing

 

[ElEye]

Thank you!

Works like a champ! Dave
[

http://flashspot.com

]