ExploreAccess

ExploreAccess


Free Version
1.2MB

Shareware
1.3MB

Screenshot

 

 

 

 

 

 

 

 

 

 

 

 

 

 


This application was developed from a need to document what we'd written and designed in Microsoft Access.

It is used to analyse an MS Access database and produce a list of statistics and details on the contents. This can then be exported to a text, XML or MS Excel spreadsheet file, which can be used as an aid to debugging, future development and documentation.

ExploreAccess was written for MS Access 200x. It will examine any earlier version of MS Access once that database has been converted to MS Access 2000 format or later (up to Access 2003).

A free demo version is available, with some limitations. If you purchase the full version, we will email you the download URL and the password to decrypt/extract the files.

Some of the information provided by the freeware version application is listed below:

  • Table names
  • Field Names, types, and sizes
  • Query names and the number of parameters
  • The "Control" queries behind Forms and Reports
  • Index Names and their types
  • Relationship names (and what is related to what)
  • Macro Names
  • Module Names and how many Functions and Sub Routines there are
  • Form names
  • Report names
  • Database statistics - records

The shareware version also provides the following information and capabilities:

  • Provides the SQL Statement for each selected Query and/or View
  • Provides a Data Definition Statement for each selected Table, Index and/or Relationship
  • Displays the contents of selected modules
  • Lists the code for selected Macros - when converted to Modules
  • Lists the Controls on selected Forms, together with their Properties and (if available) their values
  • Lists the Controls on selected Reports, together with their Properties and (if available) their values.
  • Lists and allows the translation/exports of any Data Access Pages.
  • Export options include normal text format, XML and into an MS Excel workbook
  • More information (Compressed HTML Help File, ~370kb)


Both versions can send the output to a simple ASCII text file. The output is in fixed column format, which makes further analysis much simpler.

The new version includes some more bug fixes, some program flow enhancements, improved data access pages and macros support and a CSV export option.

It also includes the ability to open another database without having to close and re-open the application, as well as enabling you to append the extracted information to an existing output file.

If you purchase the full version, we will email you the URL for dowloading it, and the password to decrypt/extract the files.

So, pick an MS Access database and have a go!

Download Free Version Now!

Shareware (Full) Version
USD 19.99

Current Version: 1.4.08

Buy Online! from Kagi

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

     

 


If you experience any problems with this website, please send email to webmaster@gwacc.com

 

 

Expect more. Get more. Pay less with 1&1 web hosting.