Hi

I'm using an Access database with ADODB.

I don't have any collection that will allow me to get the names of the tables in the database, and their fields.

I don't care if I have to open it a different way, then close it and re-open as I do now. I just want a list of tables and fields in the database.

Thanks
Robert