Recent content by cmp077

Guys thanks for your responses, however could you please be more specific and elaborate when responding. While your responses are helpful unfortunately they have not allowed me to import only the table names and corresponding field names as individual records. If you know how to do this...

Sorry I have never heard of that. Where do I find this?

If anyone know's of a way to dynamically gain access to just the table names and field names of an external access database from within a seperate access db then please let me know. This is an example of what I am trying to do. Say I have a Vendor DB with a table called tblVendor that...

lespaul - thanks for responding to me. how would I code this though to actually make it work. I am not sure. thanks again.

You don't seem to be understanding the essence of my question so let me see if I can explain it better. If I have a Vendor DB with a table called tblVendor that consists of the following fields:VendorID, VendorName & VendorState. Now imagine I have another database called Master.mdb. This...

The linked table feature or import feature will not work in this case. I do not want a collection of individual tables from various DB's in my "Master Database" To be more clear what I essentialy want is to have 2 tables (tblMasterTable & tblMasterTableFields.) Each record in the...

I want to extract all the tables and underlying fields from an access databases into another table within a seperate access database. For example, lets say I have two databases Master and Vendor. In Vendor.mdb there are 10 tables with 10 fields each. From the Master.mdb I want to run a query...