Using Microsoft Access

Access Developer Tools: Apps, Add-ins, VBA Code
Web Links

Third Party Apps, Add-ins and VBA code. These are developer tools that help in the development of Access databases. These items are generally not for the End User.  Some are freeware.

Also see: Access Example Databases and Code Repository Sites

Display # 
# Web Link Hits
1   Link   My Analyzer: the ultimate Data Dictionary Tool
Create a Data Dictionary (and more) for any Access Database. With my analyzer in your toolkit, you can get a handle on what you have in Access ... structure, relationships, and data.

2   Link   Auto FE Updater
The Auto FE Updater is a drag and drop deployment on the server. No installation required. Just download, unzip the files and place on the server. The utility does not require any extra admin privileges to test or for the users to run the utility. The IT folks in your organization do not need to be involved in your decision to use the Auto FE Updater.
3   Link   Application Starter
Application Starter for Microsoft Access is a database that handles front-end/back-end (FE/BE) database application startup needs in a multi-user environment when each user has a local copy of the FE connected to a BE on a local area network server.
4   Link   Inno Setup
Inno Setup is a free installer for Windows programs. First introduced in 1997, Inno Setup today rivals and even surpasses many commercial installers in feature set and stability.
5   Link   Inno Installer Script (Like Sagekey)
This is an INNO Setup installer script.

With this script the initial download is far smaller in size for the end user that already has Runtime installed. he script has been put together using code snippets found on different forums along with bits I did myself, so thanks go to everyone.
6   Link   InnoTools Downloader
InnoTools Downloader is an Inno Setup script and DLL which allows you to download files as part of your installation.
7   Link   Inno ISTool
ISTool helps you create scripts for Jordan Russell's Inno Setup compiler. Inno Setup is a great compiler for very professional looking setups, and the only disadvantage is that you have to create fairly complex scripts by hand.

This is where IST
8   Link   MZ-Tools - Productivity Tools for Visual Basic 6.0, 5.0 and VBA
MZ-Tools is a freeware add-in for Visual Basic 6.0, Visual Basic 5.0 and the Visual Basic For Applications editor (provided by a VBA-enabled application such as those in Office 2000-2007) which adds several productivity features to the IDE.
9   Link   V-Tools
V-Tools is a pack of nice and useful tools to enhance your developments. Those tools are available from the menu "Tools" , "Extensions". But it also has a VERY powerful searching tool (see description below).
V-Tools is FREEWARE, it won't damage your database so don't hesitate to download it. Of course, it doesn't have any virus as you can check it yourself.
10   Link   2007 Office System Driver: Data Connectivity Components
This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 20
11   Link   Microsoft SQL Server 2008 Express
Microsoft SQL Server 2008 Express is a free edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs.
12   Link   FMS
FMS has many great developer tools. The flagship product is "The Most Popular Access Add-in Ever: Total Access Analyzer"
13   Link   Smart Indenter
The Smart Indenter is a utility to tidy up VBA code by rebuilding the indentation of each line. Most developers naturally indent code within control structures, such as For...Next, If...End If, etc. Many developers also indent all the code within a procedure, to ease identification of line labels, error handling blocks etc. From that point on, there is much more variety in indenting styles, ranging from how to treat declaration lines to handling end-of-line comments.
14   Link   Peter's Software
Peter's Software products are user-friendly, useful, sometimes indispensable, development tools that are backed by quality technical support.

You can use these tools to enhance your current applications, reduce your development workload, or help build your next application.
15   Link   CompareEM Lite
CompareEM is a very simple to use utility to analyze a pair of related Microsoft Access databases, determine what has changed from one to the other, and then generate VBA code that will transform one into the other.
16   Link   ACCVER
Allows you to work with multiple versions of MS Access. Detects the version of Access used to create your MDB, MDA or MDE files and either reports the version number or starts the appropriate version of MS Access.
17   Link   Find and Replace
Find and Replace 9.0 is an add-in utility for Microsoft Access 2000 and 2002 (XP) and 2003 (as of version 9.00g)). Access 2007 is support in version 9.00j Beta. Access 2010 is support in version 9.00k Beta. It provides a "Find and Replace" function for Tables (searching design elements such as field names, not the data in the table), Queries, Forms, Reports, Macros, and Modules (Access only provides Find and Replace for Modules/CBF). Find And Replace can be used to change names of objects through the entire database (as compared to Access itself which provides minimal built-in name change propagation). In addition to facilitating name changes it has other uses, such as: a) changing the path in the connect string for attached tables (search for old path, replace with new; attachment gets refreshed) and b) searching for occurrences of a given function to enable you to change the parameters. The intended user of this module is a programmer. Additional features, available only to registered users, include a cross-reference report and set property wizard.
18   Link   SQL Server Migration Assistant 2008 for Access V4.0
Microsoft SQL Server Migration Assistant (SSMA) 2008 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2008. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects
19   Link   Bill Mosca's Microsoft Access Database Tools
I have developed several tools to make working with Access applications a little easier. I hope you find these freeware utilities useful.

Including: Properties Setter
My most popular utility by far. This tool lets you connect to an Access MDB, MDE or MDA and see the database settings, startup form and whether or not it has an AutoExec Macro. Think of it as a Startup wizard.

You can change the settings using the Properties Setter without opening the target file. Did you set the database to disallow the Bypass Key? You can reset it. Need to change any of the other database settings? Just check the boxes you want changed. And click the Engage button.
20   Link   Query Dependency Add-in for Microsoft Access 1.0
The Questica Query Dependency add-in allows Microsoft Access developers and users to view and work with the dependencies of queries in a Jet database. Two modes are included: Dependencies and References. The Dependencies dialog shows you the hierarchical dependencies for a stored query, showing the entire tree of queries and tables that are used by a query. The References dialog shows all stored queries that reference a query or table.
« StartPrev123NextEnd »
Page 1 of 3

Sponsored Links


Latest News



Powered by Joomla!. Designed by: Free Joomla 1.5 Theme, linux hosting. Valid XHTML and CSS.