Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Field List in a Query (2000)

    Is there a way to just list the field names and table names used in a number of queries used in a database?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Field List in a Query (2000)

    I'm not sure what you're asking. If you want to use the analyzer in Access, it will details the data source and fields in each query. It isn't hard to get the fields in a query, but queries can be based on several tables or even other queries, so it would help if you explain in more detail what you're trying to accomplish. Then perhaps someone will have a suggestion.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Field List in a Query (2000)

    There are some tools available in Access 2003 that will sort of do what you ask, but since you are in 2000, that doesn't help much. There are a couple of tools that will do that sort of thing with varying degrees of effectiveness. One is Speed Ferrett from Black Moshannon - it will do a list of everywhere a given string is used across a selected set of objects, such as queries. The other is a more robust product from FMS called Total Analyzer - it will document a database 6 ways from Sunday, and then some. In particular it will do a cross-reference and used-on document for selected objects - but it's pretty pricey for most developers.

    A simple alternative might be to paste the SQL text for each of your queries into Word, and then do some indexing on the field names. Hope this triggers some ideas for you.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •