Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-15-2018, 03:16 AM   #1
Derek
Newly Registered User
 
Join Date: May 2010
Posts: 166
Thanks: 13
Thanked 1 Time in 1 Post
Derek is on a distinguished road
Queries that store particular table

Hi Guys

Is there any way to find out which queries are using my specific table in MS Access?

Instead of checking each and every query , is there any other way to know which queries are using that specific table (e.g tblAudit)?

Many Thanks

Derek is offline   Reply With Quote
Old 05-15-2018, 03:21 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,799
Thanks: 140
Thanked 1,565 Times in 1,537 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Queries that store particular table

The dependency checker will do that for you, depending on which version of Access you are using
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 05-15-2018, 03:59 AM   #3
Derek
Newly Registered User
 
Join Date: May 2010
Posts: 166
Thanks: 13
Thanked 1 Time in 1 Post
Derek is on a distinguished road
Re: Queries that store particular table

I'm using Access 2010. how to use dependency checker?

Derek is offline   Reply With Quote
Old 05-15-2018, 04:22 AM   #4
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,466
Thanks: 40
Thanked 3,381 Times in 3,276 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Queries that store particular table

select the database tools tab

select the required table (don't open it)

click on object dependencies

this will show queries/forms/reports which use the table as a recordsource.

It will not show forms/reports with combos or list boxes using the table as a rowsource, nor textboxes using a domain function on the table, nor will it look at VBA to see if you have referenced the table in code.

If you need to go to this level of detail you will need a special tool - there are a number around - take a look in the code repository or google online
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 05-15-2018, 02:38 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,449
Thanks: 13
Thanked 1,422 Times in 1,355 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Queries that store particular table

You need to have Name Auto Correct turned on to use the dependencies feature. Don't remember to turn NameAutoCorrupt off when you are done.

Total Access Analyzer by FMSINC.com is a good all around tool with tons of reports.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Parent table field store sum of child table fields Alexandros Tables 6 03-16-2012 08:04 AM
Store and run calculated queries travisdh Modules & VBA 3 01-14-2011 02:20 AM
Store value from form in table flavioso Tables 7 11-05-2008 11:36 AM
value store into table cmw Forms 1 07-21-2008 10:14 AM
Use a combobox to store value in another table swisstoni Forms 2 05-20-2008 01:21 AM




All times are GMT -8. The time now is 03:25 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World