Keeping track of tables, queries and forms

[Ramesh]

Hi,

Once I cross a certain number of tables, queries and forms, i get totally
mixed up as to which tables, queries and forms are referenced by which
tables, queries and forms. What would be a simple way of recording and
keeping track of this? I thought of using a worksheet with a column each
for tables, queries and forms. But felt little cumbersome with that.

Would it be a good idea to make another table in the database itself to keep
this information?

Ideally what would be very useful is to be able to get a list of queries and
forms related to the selected table, and similarly for all the queries and
forms too.

Any inputs please?

Thanks
Ramesh

 

[John W. Vinson]

Ideally what would be very useful is to be able to get a list of queries and
forms related to the selected table, and similarly for all the queries and
forms too.

First step (free): Tools... Analyze... Documenter. Set the print options
carefully; the default settings must have been developed by someone with a lot
of stock in paper companies!

Next step: costs some money but well worth it for any serious Access
developer: Total Access Analyzer from http://www.fmsinc.com.

John W. Vinson [MVP]

 

[Douglas J. Steele]

Next step: costs some money but well worth it for any serious Access
developer: Total Access Analyzer from http://www.fmsinc.com.

And even the comical developers!

 

[Ramesh]

Thanks John.

The analyser seems to give a LOT of info!!! But i am missing what i really
need. Simply the list of queries and forms related to a particular table.
And so on for each query and form too.

any other option? I am not really looking for details inside each query and
form.

Ramesh

 

[David Cox]

A realtionships window which allowed queries to be added as well as tables
is something really needed in Access, as is a data dictionary which could be
used to discover where each field was created and where it was used. It
should be extended to VBA code as well. If such a thing existed people might
begin to think again about type prefixes. Users would want to see "pay"
fields listed together, not sparated as intpay, strpay, lngpay or whatever.

 

[John W. Vinson]

Thanks John.

The analyser seems to give a LOT of info!!! But i am missing what i really
need. Simply the list of queries and forms related to a particular table.
And so on for each query and form too.

any other option? I am not really looking for details inside each query and
form.

The Documenter does provide that information... but not in a very convenient
way. You need to either print it out and dig through each form and query; or
export the report to Word and search it there.

Total Access Analyzer does in fact give you a specific cross reference: a list
of the tables, and under each table all of the objects referencing that table.

There are some other tools that can help and aren't as expensive as the FMS
product:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com

Speed Ferret is great for specifically finding (and, if necessary, editing)
references, but AFAIK it doesn't give you a full cross-reference printout.

John W. Vinson [MVP]

 

[Susie DBA [MSFT]]

SQL Server can easily tell you which tables are referenced in a
particular stored procedure or view


maybe you should be using Access Data Projects

 

[Tony Toews [MVP]]

SQL Server can easily tell you which tables are referenced in a
particular stored procedure or view


maybe you should be using Access Data Projects

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Susie DBA [MSFT]]

Tony

**** you, I never claimed to be an employee of Microsoft.


I care too much about quality to work for an abusive company like MS