473,385 Members | 1,311 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Access - Identifiying Query Dependencies

MX1
Is there a tool or internal function to enumerate the components of an
Access DB that are dependent on another part. For example, I've got a query
that I want to edit but I can't tell whether it is used by other forms or
queries within the DB. It would be great if I could generate a report to
tell me what items use the query. I've heard Access 2003 uses this but I
use Access 2002 (XP).

Any thoughts?
Nov 12 '05 #1
1 2260
Speed Ferret. www.moshannon.com

HTH. Mike

"MX1" <mx*@mx1.abc> wrote in message
news:7P_nb.45657$ao4.110742@attbi_s51...
Is there a tool or internal function to enumerate the components of an
Access DB that are dependent on another part. For example, I've got a query that I want to edit but I can't tell whether it is used by other forms or
queries within the DB. It would be great if I could generate a report to
tell me what items use the query. I've heard Access 2003 uses this but I
use Access 2002 (XP).

Any thoughts?

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Jarrod | last post by:
I have multiple reports in one database, on one form. I need to know what reports were run when, and by Network User ID. How do I do that?
0
by: Shahzad | last post by:
dear sir/gurus i had 1st time isntalled access 2003 on windows xp, and everything is most updated access/windows/jet8 also and running very slow on my system in the begining it ask to...
5
by: Jozef | last post by:
Does anyone know if there is some sort of catch all installation program that will determine if dependencies were installed properly? I get the feeling that the Windows boys like to throw curve...
4
by: Jim M | last post by:
Just got my copy of Access 2003. Is the 'Name Autocorrect' feature in Access 2003 fixed yet, or is it still 'Name Autocorrupt', as many in this newsgroup reported in the past. I would like to...
4
by: bbdobuddy | last post by:
Hi, How do I open a Microsoft Access 2003 form from Visual Basic.net Thanks in advance bbdobuddy
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
8
by: Jeremy Ames | last post by:
I am trying to move an application from my system to a new test system. I really should have tried an easier program first, but I didn't really have a chance. My application was originally written in...
0
by: Andy | last post by:
Thanks Peter, I thought I'd give an update on this problem. My application had 2 assemblies that contained classed for the Data access and business logic layer. It was on one of them that I was...
2
by: Jon.Hakkinen | last post by:
Hi all, I'm running db2 9 on windows. I'm looking for a query to find dependencies between stored procedures. For instance if I have a procedure P that calls p1 and p2, I'd like to know that....
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.