Access Links

Access Links

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

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

  • Hits: 5235
    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.
  • Hits: 9149
    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.
  • Hits: 7254
    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.
  • Hits: 4979
    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.

  • Hits: 4531
    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.

  • Hits: 5132
    InnoTools Downloader
    InnoTools Downloader is an Inno Setup script and DLL which allows you to download files as part of your installation.
  • Hits: 5835
    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
  • Hits: 5225
    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.
  • Hits: 6609
    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.
  • Hits: 3213
    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
  • Hits: 2874
    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.
  • Hits: 4547
    FMS
    FMS has many great developer tools. The flagship product is "The Most Popular Access Add-in Ever: Total Access Analyzer"
  • Hits: 5208
    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.

  • Hits: 5698
    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.
  • Hits: 3675
    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.
  • Hits: 4606
    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.
  • Hits: 4234
    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.
  • Hits: 3233
    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
  • Hits: 6788
    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.
  • Hits: 5212
    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.

Latest News