Object Dependency Tracking

S

ShadesOfGrey

Hey folks, does anyone know if there is a way to list what specific
objects are used where within an Access 2007 database?

I have a database that I threw together for a quick-and-dirty "need
once" report that has now become the schiznitz in the office. It's a
complete kludge of queries querying other queries and all the weird
stuff that the wizards throw in. I want to salvage what I can and
start over but there are so many tables and queries that I'm having a
hard time keeping my dependencies straight.

Is there a way I can quickly tell that my XYZ_report uses tables A, B,
C and queries 1 through 5?

Thanks in advance!

Stan
 
A

Access Developer

Daniel, I'm certain that the "Object Dependency Tracking" being discussed
here is not the "Object Tracking" discussed in the books to which you refer.
Your references refer to graphics / image processing; the discussion here is
about objects in an Access database, and Access is not suitable for
heavy-duty graphics / image processing.

This is the place for discussing Access database objects; it is not the
place for discussing graphics / image processing at the level of those
books. Sorry.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Database documenter 3
access object dependencies 6
Report Query Works 2nd Time, But Not 1st 14
batch extract all tables from multiple word documents 1
Tracking Object Dependencies 1
What queries / tables are used? 2

Top