All Access Downloads/Add-Ins for Access 97 to Access 2010

Microsoft has finally re-organised all its Access downloads in one place. Just click on a column  to sort.

Office 2010 Compatibility Inspector

The Microsoft Office 2010 Compatibility Inspector compares existing (legacy) code against the Office 2010 object model by using a text search for known properties and methods that have changed. You can run the tool against specific projects. You also have the option to mark those areas in the code where text search has identified a possible object model match. The comment will include description of what was found along with possible remediation link to online content or help.

The tool integrates with both Microsoft Visual Basic for Applications 7.0 (VBA 7) and Microsoft Visual Studio 2008. It includes a basic scanner where definitions and remediation links are updated from a central online location. It also generates a summary report and a details report. The summary includes the total lines of code scanned as well as total lines identified as potential candidates for object model changes. The details report includes the module name, line number, and links to remediation for each identified issue along with color-coded flags for impact guidance.

Access Switchboard to Ribbon Converter Wizard

Exclusive to readers of Access Extra!
A new free Wizard for Access 2007 and Access 2010

This Wizard has been retired and replaced by The Access Instant Ribbon Wizard. The Wizard will automatically create an Access 2007/2010/2013 Ribbon Switchboard based on the native Switchboard Items table in your database built using the native Access Switchboard Manager.

Download

The Access Switchboard to Ribbon Converter Wizard in just two mouse-clicks turns your legacy Access Switchboard (as built by the native Access Switchboard Manager) into a fully functional Ribbon Switchboard!

Download now! Only 155kb (v1.0.1 updated 27 May 2010)

Also check-out these free new Access 2007/2010 tools:

• Ezy Access RibbonX Builder & Editor for Access 2007/2010
• Easily Migrate Legacy Access Switchboards to the Access 2010 Navigation Form

Free Access Stuff from aadconsulting.com

A reminder of some of the Access tools available free from aadconsulting.com:

Sample Date Picker for Access Databases Versatile Vista/Win7 styling and functionality.

Kiosk Dashboard Sample Access Database Mouse-driven full-screen modal kiosk dashboard.

Access Dashboard Builder A cutting-edge tool for quickly building a fully-functional Access database dashboard. You don't need a switchboard in your existing application to build a Dashboard using the Builder, and you don't need to know VBA or wrtie any macros - the builder automatically handles everything.

Office 2007 Ribbon XML File Reviewer Open any Office 2007 Ribbon XML file to review an Office Ribbon's full menu hierarchy in a tree-view with all control attributes detailed in an adjacent panel. Extensive reference resources incorporated into the GUI.

Access 2007 USysRibbons Reviewer Add-In Preview the custom Ribbons in the USysRibbons table of an Access 2007 database. Extensive reference resources incorporated into the GUI.

Access Control Center "Get Centralized Project Management for Microsoft Access" from independent review 1 Dec 2003 by Access Advisor Zone. Open the correct version of Access. Easy compacting and decompiling, workgroup switching. Projects are managed centrally. MDBs are opened by the appropriate Access version automatically. Includes a shortcut wizard, and many other features!

Access SideBar Add-In for Access 2000/2002/2003 Uses only native Access controls: no DLLs/OCXs The easy way to navigate objects in your Access MDB, the Access SideBar is available at any time. After opening an object the SideBar is hidden, and pops-up by moving your mouse to the left edge of the screen.The SideBar window size is independent of the size of the Access application window, so you can locate all objects without resizing the application window. A custom right-click pop-up menu gives easy access to useful Access Menu commands. The download also includes a second wider version.

Classic Database MenuBar and Window for Access 2007 This free sample Access 2007 database gets you beyond the frustrations of learning the new Office 2007 Ribbon and helps you learn the location of familiar commands in the unfamiliar Ribbon environment.

A Better ZoomBox A free tool for Microsoft Access versions 97 to 2003 to edit the following control properties when designing Access Forms and Reports: Record Source, Row Source, Control Source. Full find/replace functionality and saved customization font and Enter Key settings.

Access DASHBOARD® Manage all your Access databases in one application. The DASHBOARD automatically determines in which version of JET a database was created. Each file is opened in the appropriate version of Access. Use the Shortcut Builder to create custom Desktop shortcuts. Backup, Repair, Compact, and Decompile database files without leaving the DASHBOARD.

Custom Form and Report Design Toolbar A handy Custom Toolbar for Access, for faster and less tedious resizing and positioning of form and report controls: import the Toolbar into any Access97 or later database. For example, you can resize a selected group of controls to match the smallest or largest of a group, in just two mouse-clicks.

Table Links and Connections Manager The Connection Manager will find all the Microsoft Access files in the location you select and a report will display all table links and base string connections, including dependents of, and any connect errors grouped by: Jet Version, File Type, Linked Database Paths and linked tables, and Base Connection Strings. Separate reports are produced for .mdx and .adx files.

Access Database Mechanic Automates the process of attempting to recover a corrupt MS Access database, using three operations: compact & repair, decompile, and complete rebuild of an .mdb. The applet also features a fail-safe mechanism that creates a uniquely named back-up copy of the .mdb before any recovery operation is attempted. Versions for Access 2000/2002/2003 and Access 2007.

Ezy Access 2000 Access is intimidating for new users and the learning curve is steep. Here is a new tool that makes using Access a WHOLE lot easier: an Access database for retail MS Access that lets you easily create Access databases with little or no knowledge of Access.

Ezy Debug A frustration in debugging in Access 2000 and later is the clunky rigmarole required to check/set error-trapping. Now you can dramatically simplify the process. Ezy Debug is launched from the right-click popup menu in the code window of the Access VB Editor. The applet provides quick access to the Access error-trapping settings in the code window, and once invoked it is available both in the Access Database and VBE window. The current error-trapping setting is displayed and can be hanged on the fly...

New Version 1.4 of Ezy SQL Editor and Builder



I have just launched a major upgrade of my Ezy SQL Builder & Editor Add-In for Access 2000/2002/2003/2007. This new version offers a rich extension of functionality, including:

• Ezy SQL is now available both in the Access Database Window and the Office VBA Editor, so you can easily switch from one environment to the other and shuttle between each environment.
  
  
• The Ezy SQL Editor - Edit SQL and the Ezy SQL String Builder dialogs now work in partnership with the Ezy SQL VBA Plug-In dialog, which is available in any code module and allows you to easily edit a SQL string from a module.
  
  
• The Access SQL Help file is now directly accessible from within the Ezy SQL Builder.
  

Other features include:

• Font Name and Font Size Customization
• Find and Replace functionality
• SQL Keywords Assistant
• Parameter Wizard
• SQL String Parser/Formatter
• Easy insertion of table and field references
• Insert formatted SQL Strings into modules or copy to the Clipboard
• Preview action queries...

Check out the full functionality of Ezy SQL v1.4 here.

Free Access Tools from Access MVP Bob Larson

Check out Bob's web site for a cool collection of free Access tools and other useful Access tutorials and resources: btabdevelopment.com.

More Free Access Legacy Tools

Following yesterday's post, I have retired two more Access tools and these are now available for free download from aadconsulting.com:

Smart Form Builder Standard Build Access forms with navigation and auto-filtering instantly. All controls are pre-named using a standard naming convention. Launch as an Access Form Wizard or from the Add-Ins menu. Header or footer location for navigation buttons. Image or text on button faces.

Smart Form 97 (smtfrm97.zip - 80kb)
Smart Form 2000/2002/2003 (smtfrm2k.zip - 80kb)


Smart Toolbar Automatically adds full record navigation and autofiltering to any Access data form, by setting only one form property and adding three lines of code behind the form. The download file includes a sample form demonstrating SmartToolbar.

SmartToolbar 97 (smttlb97.zip - 90kb)
SmartToolbar 2000 (smttlb2k.zip - 90kb)
SmartToolbar 2002/2003 (smttlbxp.zip - 90kb)

Free Legacy Access Tools

I have retired some Access add-in products and these are now available for free download from aadconsulting.com:

Data Integrity Wizard Simplifies the process of finding duplicate record entries, null values, and like values in database tables, and checks referential integrity between related tables.

• Data Integrity Wizard 97 (datint97.zip - 52kb)
• Data Integrity Wizard 2000 for Access2000/2002/2003 (datint2k.zip - 44kb)

Ezy Dialog Form Wizard Instantly create Access dialog forms.

• Ezy Dialog 97 (ezydlg97.zip - 45kb)
• Ezy Dialog 2000/2002/2003 (ezydlg2k.zip - 65kb)

Access Knowledge Base Browser The easy way to search the on-line Microsoft Access Knowledge Base. Nearly 3,000 article references.

• KB Browser v1.3.1 (kbbrws.zip - 1.5mb)

Vizual Dezigner Easy and intuitive. Drill down into a hierarchy of all the tables, relations, and fields in your database. You can view selected field properties, and create and delete tables and fields, set indexes, create table relations, and edit other field properties.

• Vizual Dezigner 97 (vizdez97.zip - 1mb)
• Vizual Dezigner 2000/2002/2003 (vizdez2k.zip - 1mb)

Table Warehouse The ultimate source for pre-designed Access tables. Choose from 120 tables. Users can add their own tables to the Warehouse from within the Add-In.

• Table Warehouse 97 (tblwh97.zip - 320kb)
• Table Warehouse 2000/2002/2003 (tblwh2k.zip - 340kb)

Super Code and Button Builder Easier than macros! All 333 Access97 menu commands at your fingertips. The code builder is available in modules and inserts the code directly into your procedure. The button builder automatically creates a command button with code in form design view.

• Super Code and Button Builder 97 (supcmd97.zip - 42kb)
• Super Command Button Builder 2000/2002/2003 (supbtn2k.zip - 42kb)

Vizual Relations The smart way to print Access relationships.

• Vizual Relations 97 (vizrel97.zip - 33kb)
• Vizual Relations 2000 for Access 2000/2002/2003 (vizrel2k.zip - 45kb)

Untangle MS Access Relations with Ezy Documenter Premium

One of the great features of MS Access is the interactive Table Relations Window, where you graphically create and review table joins. But once the joins start to multiply, the relations window becomes unwieldy, and understanding the joins is like untangling a hopelessly tangled ball of string. This is the relations window that greets you when you open the Access 2007 Northwind sample database:


click to zoom...

You can try moving tables around in an effort to get a better perspective, but perversely it appears even more tangled:


click to zoom...

My Ezy Documenter Premium Access add-in to the rescue! With the Table Relationships Report you can in one mouse-click easily review and automatically document even the most complex table relations - click on the screenshot to zoom:


click to zoom...

This report is only one of a number of reports that this Access Add-In produces:


click to zoom...

Check it out - only US$39.95 - demo available

NEW V4.0 of Ezy Exporter Premium Edition
Add-In for Microsoft© Access

The functionality Microsoft forgot! My Ezy Exporter Premium Edition Access Add-In is the easy way to export unlimited Access objects and data in bulk.

In v4.0 you can now also export relationships, commandbars, import/export specs, and library references.

A best-seller at the Office Marketplace.

Using Access Menu Add-Ins Without The Windows Registry

Access menu add-ins require a registry entry to be available from the Access Add-Ins Menubar menu item.

In many corporate environments Access developers and users are unable to use 3rd-party Access add-ins, as users are not given permission to add entries to the Windows registry.

There is a way round this limitation, by referencing the add-in file in the database you want the add-in to be available in.

To illustrate this technique, I will use my free add-in Access SideBar Add-In for Access 2000/2002/2003, which provides an easy way to navigate objects in your Access MDB.

These are the steps to get the tool working as a library database in Access 97 or later, without the need for any changes to the Windows registry:

1. Copy the file sidebr2k.mda to a folder on your PC.
   
   
2. Open your MDB in Access and hit F11 to open the VBA Editor (VBE) window.
   
   
3. In the VBE, from the Menubar select Tools|References...
   
   
4. In the References dialog, click the Browse... button, and in the Add Reference dialog, select Add-ins(*.mda) in the Files of type drop-list, locate and select the file sidebr2k.mda, and click Open.
   
   
5. The MDA file will now appear as a reference in the References dialog:
   
   
   
   
6. Note the name of the library file in the Available references listbox, as you need the library name to call functions from the library. In my example the library name is: The Access SideBar.
   
   
7. Create a new VBA module and insert this public function:
   
   Option Compare Database
   Option Explicit
   
   Public Function pfnRunSIDEBAR()
   Call [The Access SideBar].aad_OpenLibraryDB
   End Function
   
   This code calls the function in the library database that invokes the add-in from the Access Add-Ins menu item: the syntax is [LibraryName].[FunctionName].
   
   To find out the name of the invoking function, open the add-in file in Access using the SHIFT key. From the Access Menubar select Tools|Options..., and in the Show section of the View tab of the Options dialog, ensure that the check-boxes for System objects and Hidden objects are both checked. In the Access Database Window open the USysRegInfo table. The invoking function will be the text after the = sign in the Value column for the record where the value "Expression" appears in the ValName column.
   
   
8. Save the module and call the function pfnRunSIDEBAR from anywhere in your MDB. In my work I create a custom toolbar for my development coding functions, and add a custom button to this toolbar to call a function.
   
   
   

Access SideBar: New FREE Access Add-In
for Access 2000/2002/2003
Uses only native Access controls: no DLLs or OCXs to install.

I have just uploaded my latest free Access Add-In.

The Access SideBar is the easy way to navigate objects in your Access MDB.

After opening an object the SideBar is hidden, and pops-up again by moving your mouse to the left edge of the screen.

The SideBar window size is independent of the size of the Access application window, so you can locate all objects without resizing the application window. A custom right-click pop-up menu gives easy access to useful Access Menu commands that are otherwise in disparate locations.

New Version of Ezy Documenter Premium

Ezy Documenter Premium Edition New v6.1
Add-In for Microsoft© Access 97 - 2007

Standard Edition featured in Woody's Access Watch

Ezy Documenter Premium automatically documents and prints in fully formatted Access reports all the objects in your Access database: tables and fields, table relations, query definitions, forms and record sources, reports and record sources, code modules, macros, data access pages, references, custom command bars, and database properties. Users can customize of each Ezy Documenter Database Report.

New in v 6.0:

• Linked table paths
• Data Access Pages: name, linked URL, and Data Source
• Custom Command Bars
• All Database Object Properties

New in v 6.1:

• Updated GUI
• Users can now select the export folder

Only US$39.95 including free upgrades to new versions.

How To Install Access Menu Add-Ins in Windows Vista

Thanks to Jeanette Noble and Tim Getsch at Microsoft for this update.

Under Vista you have to run an application as administrator to have the rights to set an HKLM registry key.

Workarounds to Install Menu Add-Ins on Vista:

• Run msaccess.exe as administrator and then use the Add-In manager. This workaround should work for previous versions of Access as well.


• Manually set the registry keys for the add-in. Access 2007 now supports Menu Add-In registrations under HKLM or HKCU.


• For Access 2007 only the best solution is to change the capitalization of “Menu Add-Ins” in the USysRegInfo table of the MDA or ACCDA. This is just like previous versions only you have to have Menu Add-Ins capitalized exactly as shown or the Add-In Manager will try to set the registry keys under HLKM and fail on Vista.