Retrieving all tables names from Access Databse.

Question

I want to retrieve all the table names from a access database to check that the table that should be there are there. I also would like to retrieve all the column names foreach table to make sure that is correct.

I have been searching for about an hour now and I can't find what I'm specifically looking for... or maybe I'm just using the wrong key words. ;)

Anyway. Please help.

Thanks

Vijaya Kadiyala · Answer

Hi Use the below query: SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name]1) ~) AND (Left$([Name]4) Msys) AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name; Thanks -- Vj http://dotnetvj.blogspot.com