Home
Notenregal
A-Z
Neue Noten
Instrumenten
Selbstbau
BlumenttopfTrommel
HolzTrommel
Rechtsfragen
Links
Kontakt
Qbrws the MS-Access Database Analyzer
Your help to clean your database program.
QBrws:
What is
that?Who needs QBrws?
What QBrws not does
Any costs?
How to register?
History of QBrws
Download
QBrws: What is that?
QBrws (=Query-Browser) is a Visual-Basic program, which opens a MS-Access database and lists all db-objects (like forms, tables, queries, reports a.s.o.) It performs an analysis of the dependencies of each db object. There are three types of dependencies listed:
- Red: all isolated objects i.e. objects with no relations to other object. These (red marked) objects (probably) can be deleted without affecting the database program
- blue: all integrated object, which are used direct (or indirect) by the database program, that starts at startup of the database
- black: all referenced Objects: Those objects called or referenced by other objects, which are not in the walk-down of the start-up object.
Qbrws opens the database readonly: It applies no changes on the database.
Who needs QBrws?
QBrws ist made for database developer. Even for complex databases: If you do not know, if all objects are used in your db, you should run QBrws, to identify those unused objects, and remove them. QBrws applies no changes to the db. So there is no risk, that your db will be damaged.
QBrws is not made for users. It shows views behind the sceens. That can be confusing: developers only!
What QBrws not does
QBrws is no help to solve your database problem. It gives no advice how to deal with your problems. It shows only dead objects.
QBrws analyzes the VBA-code behind the objects, but QBrws is no interpreter. Names of database objects, which are computed (concatenated) in the code, will not be detected. But QBrws tries to mark such calls to computed object names. It is on you, the developer, to guess, which names are concatenated at that lines...
In this release (4.0) QBrws supports no db-views and no diagrams. References to such objects are not detected.
This release is developed with MSAccess V9.x . (There is an old version of QBrws for V2.0 with reduced functions.)
Any costs?
Qbrws is Shareware. There is a nack-screen: you can not move or change the window size in the unregistered version. But there are no more restrictions in use. Anyway you will help us to develop further, if you register QBrws for $29.90. (For your orientation there are 4 years of development investigated in QBrws.)
How to register?
Click on the button below, and you will be linked to PayPal. There you can pay the fee in several ways (e.g. with credit cards. After confirmation of the payment you receive an email with the user-name and the password. Enter these data in the corresponding window.
History of QBrws
One of our customers asked in 1996 for support: His database does not run. An analyze showed a lot of "spaghetti" code: he had about 200 nested queries and lost any overview... So we wrote a routine (QBrws 1) to structure the chaos. Then there arose the need of a tool not only for queries, but all db objects. So QBrws grows with MSAccess V2.0 until version 3.11 But all these versions of QBrws were not able to analyze the code behind the objects. After MSA V2.0 Microsoft changed the Database format and QBrws stopped its work. So for some years QBrws went into nirvana, but the idea of QBrws survived. We took a new approach. But it had immediately been shown: The analyzing of the code behind the object is extremely complex. But after some 1000 test we now hope, that you will use QBrws with success...
Ariadne-Consulting
support(at)qbrws(dot)com
support(at)qbrws(dot)com