How to get a list of tables from a access database

[King_of_Queens]

Hi, how can i get a list of tables with columns from a access database by using cdatabase and crecordset? I want to use the list in a CTreeCtrl!

[Hesham Amin]

If you'll use Access , why not to use CDaoDatabase ? you can use methods like :GetTableDefCount , GetTableDefInfo to get CDaoTableDefInfo object. then you can get data about each table.

[Kyle Chen]

You can use ADOX to retrieve tables/views list. If you want, I can give you some code fragment. :) Kyle Chen