?
Solved

Find every instance a field or table is used.

Posted on 2011-09-29
3
Medium Priority
?
219 Views
Last Modified: 2012-05-12
I have an Access database that connects to a SQL server.  We are doing a ton of rewrites because of our external systems that have changed and they feed into this ordering database.

Is there a utility that will into an access database and tell you EVERYWHERE you used a field or table?

For example, I want to unlink a Table SSTAR_Orders.  I want something to tell me every form, query, report, module, VB code etc that used it so that I can redirect it somewhere else.  Others I don't want to redirect, but just remove, so just need to go clean them up.

Is this possible??
0
Comment
Question by:sharpapproach
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 36816932
0
 

Author Closing Comment

by:sharpapproach
ID: 36892189
VERY COOL DATABASEMX!  This worked briliiantly.....THANK YOU!!!!
0
 
LVL 75
ID: 36894518
You are welcome.  You now have a 'sharp approach' to solving these problems :-)

mx
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

765 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