Hi,

I have used ADO Connection with provider in an ASP program. I am unable to retrieve the names of tables in that database(Access 2000 database).

I need the code for retrieving the table names and their count in a Jet database.

Please inform me if there is any way.

A.D.Ramkumar

__________________
Ramkumar A D

hmm . . .i haven't tried in ASP Scripts, but if in VB Projects you can use this :
Use reference : ADO also ADO DDL and Security the code like this :

Dim cn as ADODB.Connections
Dim ct as New Catalog 'this from DDL and security class
Dim Tbl as Table
'----------- First Set The Connection ------------ Then ----------
sub GET_TBL()
    set ct.ActiveConnection = cn
    For each Tbl in ct.Tables
        'fill table name in listbox
        list1.additem Tbl.Name
    Next
    set ct = nohing
end sub

if succeeded you can convert it in your ASP scripts. Hope this is can help to solve your problems. bye