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??
7  1933 
On 30 Mar 2007 19:42:21 -0700, "TommyG" <tg*******@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??
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 -
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
On 31 Mar 2007 09:30:53 -0700, "TommyG" <tg*******@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
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" <tg*******@hotm ail.comwrote in message
news:11******** **************@ 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
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.
"TommyG" <tg*******@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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: StinkFinger |
last post by:
Hello all,
After enabling sessions for my website I have approx. 785 files in my
sessiondata folder. Now, I know what these are, however, I don't know
when/how is the best way to clean them (besides running a weekly delete
batch file).
Once the users leaves and closes the browser, the session is essential dead,
right ? So, why would I need to keep these files around ? I looked in
PHP.INI but I could not find any "cleaning" settings to...
|
by: Matej Cepl |
last post by:
Hi,
can anybody help me with the cleaning of really messy HTML from
the news site into really clean XHTML, which I would like to
then analyze with some qualitative analysis (probably exporting
to plain ASCII in meantime, but not necessarily). I can do some
little cleaning by hand, but when there some hundreds of
webpages, I hoped that I could create some XSL stylesheet for
conversion.
|
by: Pierre Saint-Jacques |
last post by:
DB2 V8.2 has a new envir. var.
DB2_USE_ALTERNATE_PAGE_CLEANING=YES
The docs. mention that this will make DB2 ignore chngpgs_thresh and use
softmax to even the rate of writing out of the bp's.
What agent process then takes over.
On a workload of 10000 trans./min., I get over 9000 bp's writes out of
my snapshot. However, LSAN Gap Cleaners, Thereshold Cleansers and
Victim Page Cleaners are all = 0
|
by: Santosh |
last post by:
Since I just started my new work, I have inherited a MS Access
database which has nearly 13000 records in a single table. Now, my
mandate is to clean the database and maybe split the table into two.
Can anyone please give me some ideas on how to clean duplicated
records without going through all the records.
Any help or idea will be greatly appreciated? I am not much of a tech
whiz but I am quite familiar with databases. I haven't dealt...
|
by: mpdsal |
last post by:
Hello. I have some very large text files that I need to import into
Access. These files are basically SAP system reports that can be up to
100,000 records but they contain a boatload of data I don't care about.
My thinking was to clean up as much as I can and edit the files into
columns, much like Excel would do, except I am exceeding the 60,000
record limit. Can anyone suggest a good free text editor that will
allow me to cleanup enough...
| | |
by: Mikey |
last post by:
Do NativeWindows get destroyed when the app shuts down?
While my app is running I can Spy++ and see my NativeWindow handle.
After app shutdown it's no longer there.
But this is confusing because if I Spy++ on the messages, and do a
DestroyHandle, I see a WM_DESTROY, but do not see this message when
the app shuts down. I presume the window has indeed been destroyed,
because Spy++ doesn't pick it up.
|
by: Sky Sigal |
last post by:
I have created an IHttpHandler that waits for uploads as attachments for a
webmail interface, and saves it to a directory that is defined in
config.xml.
My question is the following:
assuming that this is suppossed to end up as a component for others to use,
and therefore I do NOT have access to their global.cs::Session_End()
how do I cleanup files that were uploaded -- but obviously left stranded
when the users aborted/gave up writting...
|
by: Jamey Shuemaker |
last post by:
I've seen multiple threads (several in the last 6 months or so) on this
topic, but I wanted to clarify my practices. I understand the need for
cleaning object variables by setting them to Nothing and/or closing
them, but I'm not sure about the order.
As I understand it all object variables that I create like:
Set rs = SomeExistingRecordset
need to be cleaned up via:
|
by: Now You Know |
last post by:
Carpet Cleaners Los Angeles Home Carpet Rug Upholstery Cleaning
Phone 1 310 925 1720 OR 1-818-386-1022
Local Call California Wide
We offer carpet cleaning services such as; Steam Cleaning, Dry
Cleaning, Fabric Lounge Suite Cleaning, Leather Lounge Suite Cleaning,
Tile & Grout Cleaning, Mattress Cleaning, Wet Carpet / Water Damage
Restoration for: offices, homes, restaurants, clubs and hotels
http://carpetcleanersorangecounty.blogspot.com/...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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...
| |
