Getting metaData from Microsfot Access 1

[AussieDeveloper]

Greeting
I will start with my goal, I have a vb programs that will let you selct an MDB databse, thenI want to get a list of all the tables in this databse... In SQL Server its Called MetaData....and u can run some SQL to get list of all the user tables....

Once I get these tables, then I can write my SQL to get the data from them and populate a CSV file(s) with the data....

********************************************
Any code that can get me the list of the Tables in an MDB file pls?
*******************************************

Urget help and quick answer needed

Thanks

 

[KenReay]

Hi

Sounds like your level of knowledge is such you just need a pointer, in the options (see menu) untick the hide system objects tick box. This will cuase some extra tables with names beginning Msys to appear in teh database window, have a browse in there, you will find a list of objects including tables, you can write SQL to query these system tables just like any other table, but of course update them at your peril!

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[AussieDeveloper]

Thanks heaps !!
U legend !!
Its exactly as in SQL server where u have this preset views or tables that u can query...or in DB2 where you can create a MetaData Object off the current active Connection Object....

Thanks