Cleaning Up Access

[TommyG]

I am trying to clean up a current Access database that I have. I was
wondering if there was a FREE program out there that might allow me to
see the DFD of my database. If I can see this information, I think I
might be able to see where I can condense some query's to make the
information more manageable. Any help??

[Tom van Stiphout]

Re: Cleaning Up Access

On 30 Mar 2007 19:42:21 -0700, "TommyG" <tgilbride@hotm ail.comwrote:

What is DFD?
-Tom.

>I am trying to clean up a current Access database that I have. I was
>wondering if there was a FREE program out there that might allow me to
>see the DFD of my database. If I can see this information, I think I
>might be able to see where I can condense some query's to make the
>information more manageable. Any help??

[TommyG]

Re: Cleaning Up Access

On Mar 30, 11:09 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:

On 30 Mar 2007 19:42:21 -0700, "TommyG" <tgilbr...@hotm ail.comwrote:
>
What is DFD?
-Tom.
>
>
>

I am trying to clean up a current Access database that I have. I was
wondering if there was a FREE program out there that might allow me to
see the DFD of my database. If I can see this information, I think I
might be able to see where I can condense some query's to make the
information more manageable. Any help??- Hide quoted text -

>
- Show quoted text -

[TommyG]

Re: Cleaning Up Access

On Mar 30, 11:09 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:

On 30 Mar 2007 19:42:21 -0700, "TommyG" <tgilbr...@hotm ail.comwrote:
>
What is DFD?
-Tom.
>
>
>

I am trying to clean up a current Access database that I have. I was
wondering if there was a FREE program out there that might allow me to
see the DFD of my database. If I can see this information, I think I
might be able to see where I can condense some query's to make the
information more manageable. Any help??- Hide quoted text -

>
- Show quoted text -

Data Flow Diagram

[Tom van Stiphout]

Re: Cleaning Up Access

On 31 Mar 2007 09:30:53 -0700, "TommyG" <tgilbride@hotm ail.comwrote:

I don't know of any free ones. FMS has Total Access Analyzer.

I'm not at all sure what you're trying to accomplish with "condensing
queries". Create the correct ones for your application, and let Access
(Jet) do the rest.

-Tom.

>On Mar 30, 11:09 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:

>On 30 Mar 2007 19:42:21 -0700, "TommyG" <tgilbr...@hotm ail.comwrote:
>>
>What is DFD?
>-Tom.
>>
>>
>>

>I am trying to clean up a current Access database that I have. I was
>wondering if there was a FREE program out there that might allow me to
>see the DFD of my database. If I can see this information, I think I
>might be able to see where I can condense some query's to make the
>information more manageable. Any help??- Hide quoted text -

>>
>- Show quoted text -

>
>Data Flow Diagram

[Larry Linson]

Re: Cleaning Up Access

I'm not sure how you are using the term Data Flow Diagram, but in my
experience it was used in determining Requirements, and was not something
that could be reconstructed from a Relational Database.

Neither the tables, relationships, and queries, nor the rest of an Access
application necessarily implies the _flow_ of the data through the process
as described in a Data Flow Diagram.

Might you mean "schema", or "relationships" , or something else?

Larry Linson
Microsoft Access MVP


"TommyG" <tgilbride@hotm ail.comwrote in message
news:1175358653 .486264.281060@ n59g2000hsh.goo glegroups.com.. .

On Mar 30, 11:09 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:

>On 30 Mar 2007 19:42:21 -0700, "TommyG" <tgilbr...@hotm ail.comwrote:
>>
>What is DFD?
>-Tom.
>>
>>
>>

>I am trying to clean up a current Access database that I have. I was
>wondering if there was a FREE program out there that might allow me to
>see the DFD of my database. If I can see this information, I think I
>might be able to see where I can condense some query's to make the
>information more manageable. Any help??- Hide quoted text -

>>
>- Show quoted text -

>
Data Flow Diagram
>

[TommyG]

Re: Cleaning Up Access

What I am essentially trying to do, is find a way to see all the
information that I have and determine where I have duplicate
information. The database is 3 years in the making, and I think I
can condense it, if I can see where all the information is being
used. I am sure I probably have the same query in it 3 or 4 times and
under different names, because I always create a new query when I am
making a new report, and I don't always have to.

[Larry Linson]

Re: Cleaning Up Access

"TommyG" <tgilbride@hotm ail.comwrote

What I am essentially trying to do, is find a way to see all the
information that I have and determine where I have duplicate
information. The database is 3 years in the making, and I think I
can condense it, if I can see where all the information is being
used. I am sure I probably have the same query in it 3 or 4 times and
under different names, because I always create a new query when I am
making a new report, and I don't always have to.

It's going to be a little difficult to determine (almost-)identical
queries... it's a given they don't have the same name. For searching to
find where, or if, a text-string is used, I've had good luck with Speed
Ferret (and know others who have also). But, you have to search for each
test string manually... there's no "launch into preset analysis" mode.
http://www.moshannon.com. Rick Fisher has a similar product, shareware,
Access Find and Replace, http://www.rickworld.com. There are others, but I
haven't used them. Both of these work very nicely.

Larry Linson
Microsoft Access MVP