How to use Tabledef to get list of tables in access (1 Viewer)

[method]

I wonder how i in VB6, i can use Tabledef to get the list of tables in an access database and display it in a combo box. I be hapy if some one show me how. thanks

 

[Mile-O]

You could just use ADO to create a query recordset using the query:

SELECT Name
FROM MSysObjects
WHERE Type = 1 AND Name Not Like "MSys*"
ORDER BY Name;