What it is
DBLimn is a Microsoft Access® database analysis tool. It creates a map of the database objects (tables, fields, forms, queries, reports, modules, and controls) and their relationship to each other. From that map you can view the dependencies between the objects. This tool can generate a map of the objects that depend on a particular object or a map of the objects that a given object depends upon.
DBLimn can also run automated tests on database expressions. For instance the where clause of a query can be tested against the data in the tables and the tester can report if the expression is fully tested by the data.
|Purchase DBLimn Version 1.5|
Download a 30 day trial version
Pay with credit card
Pay through Pay Pal
How it works
The main screen has the database map on the left. The bottom of the screen shows the properties of the selected object. Double clicking on an object on the left opens up the objects that it contains.
Right click on an object opens a menu. Click on dependents to open a dependents page that lists the objects that depend on the object above for that object. The toolbar at the top is used to filter the objects according to how they are related. Also the objects can be sorted in a variety of ways.
The tests button opens a page that shows the tests for the database. The test has a main expression. Database objects are automatically opended and the records are iterated. The main expression is evaluated, if the main expression is ever false then the test is failed otherwise it is passed. There are also coverage expressions. The coverage expressions are the different ways the main expression can be true. The test objects are the main objects involved in the tests. The variables are associated with the objects in the variables list.
After the test is run then the results can be viewed in the log page. The expression tree shows the calculations and Where clause for the query. The effects of the calculations and where clause on the data can be observed in the log.
Any part of the expression tree can be examined. Right click on a node and select an option. For example the rows for which the selected node is true can be highlighted or filtered.
Also the columns that are involved in the expression node can be highlighted.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.