How to retrieve database data from several dbs to one treeview??? 1

[ixian]

Hey all,
Okay I have a 9 Access db that I need to convert into a treeview.

The lay out will be

parentFolder1(db1)
childFolder(tbl1)
grandchildFolder(rs1)
...
grandchildFolder(rs....)
parentFolder2(db2)
etc
to the last one

Since each db is a large amount of data(the smallest 2Mb, 16 tables and 400+ recordsets--the largest over 8 Mb, 31 tables and 1000+ recordsets), I think it is the best way to do this in this layout.

Any suggestions??? How can I get it under one treeview???

 

[Guru2B]

Hi,

I'm not sure of the node limits for the tree view control but you could open each DB, add the parent node, iterate through the db and add your tables and what have you, close that DB, open another and repeat.

 

[ixian]

Guru2b,

great thanks..mind freeze on this one

Aaron

 

[Guru2B]

Have been having those moments all day. Don't feel bad.