Hi all -
I'm wondering if anyone has (or knows of) a tool that will allow me to
search through VB code, tables, queries, reports, forms, and other
objects, for references to all other types of objects.
That's not really that clear, so here's an example:
If I have a table named
"table_i_would_ like_to_delete_ but_don't_know_ if_any_object_i s_using_it",
is there a way I can determine what forms/queries/reports/VB
code/other objects are getting data from it?
Another way to think about it is almost like a reverse lookup. So
let's say I have a form that I know is bound to a query. Well it's
easy to say "ok, this query is being used by this form." But I want
to programatically go through all other objects and figure out what
else is using/bound to this query. It's like there is a one-to-X
relationship between an object and X number of other objects and I
want to figure out what X equals (any number >= 0) and then what the
names of those X objects are.
To do this seems like it would take a fair amount of work, but I can't
imagine that others haven't had the need for this type of tool in the
past. There might even be something built into Access that I don't
know about (would M$ actually create something that robust and
useful?).
Thanks in advance,
Jon LaRosa
TDC www.tdcorp.org 2 2230
Two tools that are well-regarded for this purpose are:
Speed Ferret, http://www.moshannon.com, a commercial software package (I've
used and liked this one) and FindAndReplace, from http://www.rickworld.com,
a shareware package (I last used this one in its Access 2.0 version).
Also, Total Access Analyzer from FMS, Inc., provides a general
crossreference report and CodeTools from FMS, Inc. has a feature to provide
an unused objects output, if I recall correctly. FMS, Inc. is at http://www.fmsinc.com.
Larry Linson
Microsoft Access MVP
"Jonathan LaRosa" <jl*****@alumni .brown.edu> wrote in message
news:e6******** *************** ***@posting.goo gle.com... Hi all -
I'm wondering if anyone has (or knows of) a tool that will allow me to search through VB code, tables, queries, reports, forms, and other objects, for references to all other types of objects.
That's not really that clear, so here's an example:
If I have a table named "table_i_would_ like_to_delete_ but_don't_know_ if_any_object_i s_using_it", is there a way I can determine what forms/queries/reports/VB code/other objects are getting data from it?
Another way to think about it is almost like a reverse lookup. So let's say I have a form that I know is bound to a query. Well it's easy to say "ok, this query is being used by this form." But I want to programatically go through all other objects and figure out what else is using/bound to this query. It's like there is a one-to-X relationship between an object and X number of other objects and I want to figure out what X equals (any number >= 0) and then what the names of those X objects are.
To do this seems like it would take a fair amount of work, but I can't imagine that others haven't had the need for this type of tool in the past. There might even be something built into Access that I don't know about (would M$ actually create something that robust and useful?).
Thanks in advance, Jon LaRosa TDC www.tdcorp.org
I have a database which will tell you what queries use what tables and what
reports and forms they are used for. Ditto subforms, tables etc, but the
database does not analyse code. If you want a copy, e-mail me direct.
Phil
"Jonathan LaRosa" <jl*****@alumni .brown.edu> wrote in message
news:e6******** *************** ***@posting.goo gle.com... Hi all -
I'm wondering if anyone has (or knows of) a tool that will allow me to search through VB code, tables, queries, reports, forms, and other objects, for references to all other types of objects.
That's not really that clear, so here's an example:
If I have a table named "table_i_would_ like_to_delete_ but_don't_know_ if_any_object_i s_using_it", is there a way I can determine what forms/queries/reports/VB code/other objects are getting data from it?
Another way to think about it is almost like a reverse lookup. So let's say I have a form that I know is bound to a query. Well it's easy to say "ok, this query is being used by this form." But I want to programatically go through all other objects and figure out what else is using/bound to this query. It's like there is a one-to-X relationship between an object and X number of other objects and I want to figure out what X equals (any number >= 0) and then what the names of those X objects are.
To do this seems like it would take a fair amount of work, but I can't imagine that others haven't had the need for this type of tool in the past. There might even be something built into Access that I don't know about (would M$ actually create something that robust and useful?).
Thanks in advance, Jon LaRosa TDC www.tdcorp.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Atlas |
last post by:
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox
7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.
Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as the
DB platform.
Low on time.
|
by: Hank Reed |
last post by:
Microsoft Access help says the maximum number of Modules, Forms, and
Reports is 1000. It appears that linked tables do not count. What
about local tables?
Help also says that the maximum number of open tables is 2048
(or less). That would seem to leave linked tables out of the above
mix.
Can anyone comment on these limits or quote personal
experience?
|
by: Georges Heinesch |
last post by:
Hi.
I created a project including tables, queries, forms, subforms, reports,
code, a.s.o. I would like to give this project to users, which should
just use the main form. This main form deals with everything, hence
there's no need to see the tables, queries, ...
How can configure my project so that users don't get access to the
tables, queries, code ... ? They should just be able to use one single form.
|
by: Mike Thomas |
last post by:
Access 2000 - Is there a 3rd party tool available, or perhaps some method
built into Access 2000, which could isolate unused Access reports, queries,
forms, etc?
I have a 5 year old app which has not always been cleaned up. I know there
are quite a few such no longer used items. I have a "Find" utility which is
good, but I need to look for every component individually - it is very time
consuming because there are hundreds of components...
|
by: temp |
last post by:
Hi,
My boss is asking me to generate a column mapping report of all the
queries. Basically, we get our data from ORACLE. There's a queary that
create new table from ORACLE tables. Then, there are reports and
queries that uses the new table.
Is there an add in or tool that can generate mapping reports of the
queries.
| |
by: leavandor |
last post by:
Hello all,
I've come upon a problem when trying to find where some data in my .mdb
file is coming from. This database was designed by someone else
several years ago, and now I've been put to task at redesigning it for
my company's current needs. However, I've been trying to find out
where exactly the table that is feeding data into several reports and
forms is coming from. There is no linked table object in the Tables
list of the...
|
by: brettclare |
last post by:
I have linked a large SQL Server table to Access, however 'only'
2,195,439 records are shown and are available to query. Can I increase
the size (cache??)/number of records showing in Access?
Thank you.
|
by: NickName |
last post by:
I understand it's easy to list all saved queries of a given Access
database via Msysobjects system table. However, I have not seen any
posting over this NG or other similar ones that also include SQL
statement(content) of these queries, though I've noticed some VB code
for that. Is that because it's simply impossible to get a query
content (not query resultset) from a SQL stmt?
Thanks in advance.
|
by: davidanthonyedwards |
last post by:
Please Help,
I have been given an Access application to have a look at, am newbie,
etc.
When I open the mdb file with the shift key down so that the menu
options are available I can see all the reports, queries, forms and
there are plenty. But I cannot see any of the tables, as you would
normally, and I think there are up to 40.
I can find the table names from viewing one of the queries and then
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |