Art,
You can use the Database Documenter in the Database Tools ribbon. Select all the pertinent tables and step through to the report. Close the report without saving. This actually stores the information in doc_tblObjects in a wizard file ACWZUSR12.ACCDU.
Use the External Data ribbon to find ACWZUSR12.ACCDU. My file (Access 2010) is found in C:\Users\-myloginhere-\AppData\Roaming\Microsoft\Access\. Link (or import) the table doc_tblObjects. Then create a query with this SQL:
SELECT doc_tblObjects.Name AS TableName, doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType, doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects INNER JOIN doc_tblObjects AS doc_tblObjects_1 ON doc_tblObjects.ID = doc_tblObjects_1.ParentID
WHERE doc_tblObjects_1.TypeID=11;
You can then create a crosstab or paste into Excel or whatever.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Thu, 24 Apr 2014 13:31:59 -0700
Subject: [MS_AccessPros] Looking for a field
Is there a tool in Access to find the number of occurrences of a field across multiple tables and what tables contains them?
Thank you,
Arthur Lorenzini
Sioux Falls, SD
You can use the Database Documenter in the Database Tools ribbon. Select all the pertinent tables and step through to the report. Close the report without saving. This actually stores the information in doc_tblObjects in a wizard file ACWZUSR12.ACCDU.
Use the External Data ribbon to find ACWZUSR12.ACCDU. My file (Access 2010) is found in C:\Users\-myloginhere-\AppData\Roaming\Microsoft\Access\. Link (or import) the table doc_tblObjects. Then create a query with this SQL:
SELECT doc_tblObjects.Name AS TableName, doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType, doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects INNER JOIN doc_tblObjects AS doc_tblObjects_1 ON doc_tblObjects.ID = doc_tblObjects_1.ParentID
WHERE doc_tblObjects_1.TypeID=11;
You can then create a crosstab or paste into Excel or whatever.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Thu, 24 Apr 2014 13:31:59 -0700
Subject: [MS_AccessPros] Looking for a field
Is there a tool in Access to find the number of occurrences of a field across multiple tables and what tables contains them?
Thank you,
Arthur Lorenzini
Sioux Falls, SD
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar