Solved

Trace a field in database

Posted on 2011-09-13
7
179 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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