Fetch list of table names in access to a record set
 

Hello all

What is the sql query that fetches all the table names that exist in the
access database...

i need to fetch this to a record set and i am uisng java with odbc to access
ms access?


/thanks in advance
PRash

Fetch list of table names in access to a record set
 

try:

Set oRst = oCon.OpenSchema(20) 'adSchemaTables



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Prashantha Weerakoon wrote :

Hello all

What is the sql query that fetches all the table names that exist in
the access database...

i need to fetch this to a record set and i am uisng java with odbc to
access ms access?


/thanks in advance
PRash