Solved

Find every instance a field or table is used.

Posted on 2011-09-29
3
209 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
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone 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

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…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

856 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