Solved

Find every instance a field or table is used.

Posted on 2011-09-29
3
196 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 - Access MVP) 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
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.

707 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

12 Experts available now in Live!

Get 1:1 Help Now