Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Find every instance a field or table is used.

Posted on 2011-09-29
3
Medium Priority
?
221 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

636 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