find if the coumn exists in a number of tables

  • Thread starter dtonse via AccessMonster.com
  • Start date
D

dtonse via AccessMonster.com

I am new to MS access and have an assignment to find out if the particular
column name exists in about 50 different tables in a given MS access database.


Any suggestions?
 
G

Guest

Go to TOOLS - Analyze - Documenter - Select the TABLES you want - under
Options select field names. Click OK and then save as Word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Record not showing if no record in many table 1
How to find out if a given table exists (with VBA code) ? 1
Tables/Queries Exists() Function 2
Exists() function seems broken.. Any help? 12
Access Access Daisy Chain Linked Tables 0
Looking for Help With Access - Writing a criteria that crossreferences 2 tables 2
Checking if data exists another table and, if yes, extracting a value 0

Top