Access Experts

My Free Access Tools

 

FRONT-END AUTO-UPDATE ENABLING TOOL (Works for all versions 2000 and up)

Microsoft Access Front-End Auto-Update Enabling Tool - allows you to quickly add auto-updating to your front-ends (PLEASE NOTE: This tool is primarily meant for networked users that have direct access to the backend location). Revised file updated 06 Sep 2008

Documentation for the Auto-Update Enabling Tool

 FRONT-END AUTO-UPDATE ENABLING TOOL (version for secured database using mdw file)

Microsoft Access Front-End Auto-Update Enabling Tool (for secure db) - allows you to quickly add auto-updating to your front-ends that need to use a workgroup file and shortcut to open the database using that shortcut.  This version is courtesy of Tom Knight of the London Borough of Hillingdon (thanks Tom!).

Documentation for the TKnight version of the Auto-Update Enabling Tool is included in the above zip file.

FRONT-END AUTO UPDATE ENABLING TOOL (version for SQL Server/SharePoint).
Microsoft Access Front-End Enabling Tool (for SQL Server/SharePoint)
Documentation will be coming soon (5 Nov 2012).


 

BACK-END AUTO-UPDATE TOOL

Back-end Auto-Update Tool - allows you to add tables, delete tables, copy tables, add table columns, or delete table columns especially for remote customers.  This will not merge data in tables.

Documentation for the Back-End Auto-Update Tool

 


 

PROJECT PASSWORD REPOSITORY

This is a tool which lets you store passwords for various Access databases, including one for the backend database, the code modules, and frontend, if you have such set.  This will let you keep them somewhere so that you can access them quickly for opening up those items.  There are copy to clipboard buttons which will let you quickly copy the password to the clipboard so you can paste it into the dialog.

Project Password Repository (Access 2000 Format)

 


 

CODE STORE

This is a tool for storing code and being able to quickly copy it for use in your programs.  I have included some code samples in the tool as a demo to how to use it.

Code Store (Access 2000 Format)

 


 

DATABASE RESET TOOL

This tool will allow you to delete all of the data in your non-linked tables and then compact which will remove the extra space leftover from the deleted data.  The compact will also restore the autonumber sequence, even though we shouldn't care what the autonumbers are if they are used properly. 

You can choose to remove tables from the list (such as lookups) that you don't want data deleted from and you can choose the order in which the delete happens, if that is important to you due to parent/child relationships being set.

Database Reset Tool (Access 2002-2003 Format)    Database Reset Tool (Access 2000 Format) 
(7/14/2009 - Fixed a bug which kept the last file selected from being removed from the list.  Also added a "Select All" checkbox to the form where you can remove tables from your list.)
(5/1/2009 - Fixed file has been uploaded which allows selection of ACCDB files as well.)
(5/13/2009 - Added the ability to save definitions, select multiple tables to remove from the list at one time, and works with MDE and ACCDE files now too.)
 

 

DATABASE MERGE ANALYSIS TOOL

This is a tool which I wrote to help me at work where I had to merge two databases (two COMPLEX databases) together and needed to know what objects were in one and not in the other.  This is the first, of probably many, iterations of this tool and I will be updating the download as I get it refined further.  But I wanted to share it with anyone who might be needing something similar.

Database Merge Analysis Tool (Access 2002-2003 Format)   Database Merge Analysis Tool (Access 2000 Format)
(5/1/2009 - Fixed file has been uploaded which allows selection of ACCDB files as well.)

 

 


SYSTEM INFORMATION TOOL

This is a simple EXE that you can run without installing to get your comprehensive system information.