Solved

Trace a field in database

Posted on 2011-09-13
7
178 Views
Last Modified: 2012-08-13
Experts,
In the macro driven database I've inherited not a single relationship was established between tables (go figure).
I am "hoping" that there is a some tool that can trace a field identifying all tables, queries, macros, forms, or reports where this is being used.
I've attempted to do this manually.
0
Comment
Question by:Frank Freese
  • 4
  • 2
7 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 36531991
0
 
LVL 75
ID: 36531993
Invaluable - I use it daily ... and have since its inception.

mx
0
 

Author Closing Comment

by:Frank Freese
ID: 36532103
got it - this is perfect thank you
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 75
ID: 36532118
You will love it ... best F&R ever!  Also, many somewhat subtle features.  

mx
0
 
LVL 42

Expert Comment

by:dqmq
ID: 36532175
And pray for consistent naming standards.
0
 

Author Comment

by:Frank Freese
ID: 36532609
mx:
this is fantastic!!!!!!
0
 
LVL 75
ID: 36532647
worth 100x the cost.
when you have time, read over the help file ... to become familiar with all the cool, not so obvious features.

mx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now