i want to write a code that will help me read database structure(.accdb in particular), meaning it will give me number of table that are there, there structure i.e. no and name of fields index info in each table. In short everything thats related to structure. i am not saying values or data stored in table.
e.g. if i have a DB, say xyz.accdb and has 3 tables table1, table2, table3
table1 has fileds name, no
table2 -> adress, name
table3 -> name occupation
now my code should return number of tables i.e. 3, number of fields in each table which is 2 here in each case, plus name of individual fields in each table.
i hope i have made myself clear.
any suggestion, idea, piece of code, anything...preferably in MSVC++... will be deeply appreciated. Thanks in advance.