Hi Sherry,

You can use the ADORecordset object to parse all the tables, fields and views out of an Access Database. I cover the basics of this in the September Ask Advisor column if you can wait a month. Otherwise, you can figure it out from the ADODB documentation.

pamela