List Database table through ASP

abhisheksud · September 5th, 2005, 05:10 AM

Hi
i have a ms access database which contains many tables and each table many diffrent records are stored. i want to use a search feature which finds a particular data from all tables and gives results...however in the beginning i just want that whatever tables are present in the database they just get listed out..i have used the openschema method but during runtime it give me error that "Object or provider is not capable of performing requested operation"...
what could be the problem...
the full text code is

<%@ Language=VBScript %>

<HTML>
<HEAD>
<title>RESULTS</title>
</head>
<body bgcolor="#000000" text="#ffffff" link="#ffff00" vlink="#ffff00">

<%
Set Rs = ObjConn2.OpenSchema (adSchemaTables)

while not Rs.eof
Response.Write Rs ("TABLE_NAME")
Rs.movenext
wend
%>

Please help me out with this...
Abhishek