Category Archives: Microsoft Access Products

Jul 07

Total Access Analyzer Ships for Microsoft Access 2013

Posted on by

Microsoft Access 2013FMS is pleased to announce the release of Total Access Analyzer, version 15, for Microsoft Access 2013. Total Access Analyzer 2013 is our 10th major release of this product since its debut with Access 1.1 in 1993.

Total Access Analyzer provides detailed documentation and analysis of your MS Access databases to help you better understand how your objects work together, detect problems, improve your designs, and enhance performance.

Over 300 Types of Issues are Detected

Total Access Analyzer examines all your database objects in detail to find 300+ types of issues including errors that crash your application, unused objects and VBA code, design inconsistencies, and other best practices to maximize your investment in your Access applications.

390 + Professional Quality Reports

Over 390 filterable and customizable reports are available to document your applications and help you develop more efficiently. Reports include table/field dictionary reports, object cross-reference lists, module printouts, application flow diagrams, field and SQL consistency reports, and much more.

Discover why so many Microsoft Access enthusiasts made Total Access Analyzer the most popular Microsoft Access add-in of all time and the winner of every Best Access Add-in Award for decades.

main-menu-2013[1]

New Features

Total Access Analyzer is now available for Microsoft Access 2013 with many new features:

  • Total Access AnalyzerSupports Microsoft Access 2013, 32 and 64-bit versions
  • New documentation of Conditional Formatting
  • Documentation of Navigation Control and Buttons
  • Documentation of Web Controls
  • New Control Type Reports
  • Support Procedure Calls to Libraries
  • 3 New Module VBA Coding Suggestions
  • Enhanced VBA Module Parser for Compiler Conditionals
  • New Search Bar for Selecting Objects
  • Improved Open Documentation Form
  • Report Filter Shows Count of Issues
  • New Treeview with 64-bit support
  • New user manual and help file
  • and more!

Here’s a complete list of new features.

Free Demo

A demo is available for you to see the types of documentation it generates using the sample Northwind database. Look at the results, filter and search it, and see the reports it generates: Demo Download

Existing Customers

Existing Total Access Analyzer customers can upgrade for a discounted price.

Jun 01

Total Access Admin 2003, Version 11.6 Ships

Posted on by

adminThe release of Total Access Admin 2013 added many new features. Due to customer demand, we’ve updated Total Access Admin 2003 from version 11.5 to 11.6 to include the new features.

The primary difference between the 2003 and 2013 version is that the 2003 version doesn’t require installing Access 2007 or later on the machine in order to support the ACCDB database format. It supports Access databases in MDB formats and does not require Access to be installed on the PC.

Many New Features

Total Access Admin 2003 version 11.6 includes these enhancements:

  • Maintain a list to translate computer names to more friendly user names
  • Manage up to 100 database in one screen (up from 50)
  • Specify a time to close the program
  • More command line parameters
  • New forms to view the activity log, and more.

Read our New Features page for details.

Free Trial

Download the free, fully-functional Trial Version to see how helpful Total Access Admin can be for you.

Supports All Microsoft Access Versions

Total Access Admin 2003 supports MDB databases created in any version of Microsoft Access. Existing customers can upgrade at a discounted price.

Apr 24

Total Access Admin 2013 Ships

Posted on by

adminTotal Access Admin lets you monitor users going in and out of your databases in real-time. See who’s currently in your database and who recently exited, create a log of connections and disconnects, compact the database after everyone exits, etc. Monitor all the databases across your network from one installation of Total Access Admin.

Many New Features
Total Access Admin 2013 includes many new features. You can now:

  • Maintain a list to translate computer names to more friendly user names
  • Manage up to 100 database in one screen (up from 50)
  • Specify a time to close the program
  • More command line parameters
  • New forms to view the activity log, and more.

Read our New Features page for details.

main-menu-new

Free Trial

Download the free, fully-functional Trial Version to see how helpful Total Access Admin can be for you.

Supports All Microsoft Access Versions

Total Access Admin 2013 supports ACCDB databases created in Microsoft Access 2013, 2010 and 2007, plus MDB databases created in any version of Access. Existing customers can upgrade at a discounted price.

Apr 16

Total Access Detective Review by Daniel Pineault

Posted on by

MVPLogo[1]Microsoft Access MVP, Daniel Pineault, wrote a very nice review of our Total Access Detective program recently. Total Access Detective is a Microsoft Access add-in program that finds all the differences between two Access databases or two objects in one database. Changes with table and query structures, field properties, form and report controls and properties, macros, module VBA procedures and lines of code, and even data are detected.

Daniel found Total Access Detective very helpful when confronted with the challenge of determining exactly what changed between two Microsoft Access databases. Rather than manually and tediously trying to determine what changed, he used Total Access Detective to quickly generate a comprehensive comparison to find objects in one database and not the other, and a detailed comparison of objects with the same name. With Total Access Detective, he was able to pinpoint all the differences and make the necessary adjustments.

We were pleased he concluded with this:

Microsoft Access Difference DetectorFinal Verdict
“I am once again quite confident in putting my stamp of approval on this tool. If you are in a situation in which you quickly need to identify all the differences between multiple databases, FMS’ Total Access Detective will make short work of the job at hand! …
A very nice, easy to use and most importantly, effective and thorough tool!”

To learn more about what Daniel discovered and his experience, read his full Total Access Detective Review.

Thanks Daniel!

Nov 05

Total Visual SourceBook 2013 Ships

Posted on by
Total Visual SourceBook Total Visual SourceBook

We are delighted to announce the release of Total Visual SourceBook 2013. Total Visual SourceBook is our royalty-free source code library for Microsoft Access/Office VBA developers and Visual Basic 6 (VB6) developers.

code-explorer-web

The new 2013 version is an upgrade to our Total Visual SourceBook 2007 version. The new version is especially designed for the new features introduced in Microsoft Access/Office/VBA 2013 and 2010. It can also run in Access/Office 2007 and older versions through Access/Office 2000.

New Features

Total Visual SourceBook 2013 includes 35 new modules, 25,000+ more lines of code, enhancements to existing modules including VBA code that’s compatible with 32 and 64-bit versions of Office.

The user code database can now be upsized to SQL Server to simplify sharing code among your developer team. The new version also includes many enhancements to the code browser to simplify your experience in viewing, searching, adding, editing, and applying different error handlers to the source code.

For a complete list of enhancements, visit our New Features page.

Additional Resources

Aug 26

Free Update for Total Access Analyzer 2010 and 2007

Posted on by

Total Access AnalyzerTotal Access Analyzer is the most popular Microsoft Access add-in of all time. Analyzing all the objects and code in your database, Total Access Analyzer generates detailed documentation and detects 300+ ways to fix, improve, and speed up your Access applications.

We have released free updates of Total Access Analyzer 2007 and 2010 to existing customers:

The updates include the following fixes and enhancements:

  • Module Cross-Reference incorrectly listing procedures that didn’t exist when they existed
  • Improved SQL query parsing to better cross-reference table and field names passed as function parameters
  • For secure databases, document queries even when logged in without admin rights
  • Support documenting library references of long DLL file names and paths
  • Setup issues resolved for certain machines and motherboards
  • For Microsoft Access 2010’s 64-bit version, support for Windows 8

Existing customers were already notified with download instructions.

Jun 06

Total Access Emailer Ships for Microsoft Access 2013

Posted on by

Total Access EmailerTotal Access Emailer is the most popular email automation program for Microsoft Access. It simplifies the sending of personalized emails with Access data and reports to everyone on your list.

Total Access Emailer is now available for Microsoft Access 2013. Total Access Emailer 2013 includes many enhancements since the prior release of Total Access Emailer 2010 and the Version x.6 for pre-Access 2010 versions:

  • Enhanced setup for Windows 8 and 64-bit installations
  • Supports differences in VBA code between Microsoft Access 2013 and 2010
  • Improved support for linked tables in SQL Server and Access databases including situations when connections are lost
  • User interface improvements to better manage editing and duplicating email blast specifications
  • Professional Version VBA library detects if the user’s machine has not run the runtime distribution EXE
  • Improved display of record counts for repeating multiple email blast broadcasts
  • Improved error handing and reporting
  • Updated user manual and help file

Here’s a complete list of new features.

download-trial-blueDownload the free trial version and send your own personalized emails from Microsoft Access.

Mar 22

Total Visual Agent Ships for Microsoft Access 2013 and 2010

Posted on by

Microsoft Access Database SchedulerTotal Visual Agent for Microsoft Access DatabasesAutomate Microsoft Access Database Compact and Other Chores

We are very pleased to announce that Total Visual Agent 2013 is now shipping.

Don’t Forget System Administration for Microsoft Access Database Solutions

A professional Microsoft Access database application needs ongoing system administration. It’s an area that many MS Access developers neglect and causes problems when things go wrong (database corruption, missing backups, disaster recovery, etc.):

Enterprise Quality System Administration with Audit Logs and Email Alerts

Total Visual Agent has provided an Enterprise Quality solution for almost 20 years by giving organizations a reliable way to perform their critical tasks on a 24/7, 365 days a year basis. A detailed audit log documents each action that is performed, and sends emails if errors are encountered.

Schedule Events, Databases, and Actions to Perform

Total Visual Agent automates and schedules Microsoft Access tasks. It ensures repetitive tasks are completed reliably. Tasks such as database compact and repair, zipped backups, rolling backups (e.g. 7 copies for each day of the week), running macros, running Windows command lines, making copies of table data, collecting database statistics such as size and record counts, etc. Easily schedule tasks for the middle of the night and know they’ll be completed.

Events can be scheduled every X minutes, hourly, daily, weekly, monthly or just one time. You can specify the days of week and time periods that it runs to limit processing to off-hours. Select the databases and directories (including subdirectories) to manage with support for workgroup security and database passwords.

Includes a Windows Service for Secure Processing and Reliability

Once defined, the events and tasks can be run by our Monitor program that is a standard Windows program.

Alternatively, Total Visual Agent includes a Windows Service, so you can run your tasks without having anyone logged on the machine. The Windows service is a more secure, robust solution since it can automatically restart if the machine reboots.

New Features in the 2013 Version

A huge number of new features were added in this 2013 release from the previous 2007 version:

  • Microsoft Access 2013Support for Microsoft Access 2013 and 2010, plus 2007
  • Support for 64 bit Operating Systems
  • Simplified Startup and Easier Management of Multiple Microsoft Access Versions
  • Import Settings from Multiple Versions of Total Visual Agent
  • Test All Actions for an Event, Database, Directory or Task Group
  • Create Events that Run Every X Minutes
  • Create Events that are Limited to Periods Spanning Midnight
  • Process Directories with Managed Databases
  • Data Extract Tables are Keyed
  • Run Macros for Database Password Protected Databases
  • Pause for a Fractional Minute
  • Compressed Archive File Names Support Multiple Extensions
  • More Detailed Activity History Log with Deletions
  • More Detailed Database Statistics with Deletions
  • Add Your Comments to Events, Directories, and Actions
  • Simplified Addition of New Actions
  • More Modern and Improved User Interface
  • New User Manual and Help File

For complete list, visit New Features in Total Visual Agent 2013.

Download a Free Trial Version

A fully functional trial version is available for download so you can run it on your system with your databases.

Contact Us

  • Visit our Support Site if you would like to submit any questions to our technical support team.
  • Place an order online. Existing customers can upgrade at a discounted price.
Feb 12

Portland Oregon Microsoft Access User Conference

Posted on by

Silver Falls State Park, Oregon
May 4-6, 2013

FMS President Luke Chung is one of the featured speakers at this annual Microsoft Access conference hosted by the Portland Access User Group. This will be his third year speaking at this wonderful event.

Enjoy an amazing, rustic getaway to a beautiful state park with fellow Microsoft Access enthusiasts. Book early so you can stay at the limited number of cabins available at the conference center. The conference fees are amazing low and includes meals.

LightSwitch and Microsoft AccessLuke will participate in various talks on Microsoft Access development, running a business, and creating solutions using Visual Studio LightSwitch. He’ll also be staying at the site during the entire conference, so you’ll have plenty of opportunity to meet him formally and informally.

For more information, visit the conference site.

Dec 31

Total Visual CodeTools 2010 Updated for Microsoft Access Office VBA and Visual Basic 6

Posted on by

Microsoft Access 2010 VBATotal Visual CodeToolsMicrosoft Access VBA, VB6 Module Coding ToolsModule Code Cleanup and Builders

Visual Basic 6An update of Total Visual CodeTools 2010 is released with support for Microsoft Office/Access 2010, 2007, 2003 and Visual Basic 6.0. Several enhancements were made to improve the New Procedure Builder, VBE color scheme builder, icons for the toolbars, setup program and IDE integration, etc. Here are the details on the latest enhancements of Total Visual CodeTools.

Total Visual CodeTools is an add-in to your Office/Access/VBA and VB6 integrated development environment (IDE) that helps you write, clean-up and deliver better solutions. Available from the IDE menu or a toolbar, a variety of tools help increase your efficiency and consistency when writing code and taking over someone else’s work. Features include:

  • Code Builders to create new procedures, properties, ADO and DAO recordsets, message boxes, select case statements; convert SQL strings, copy control event procedures, use the Format and DateDiff functions, comment blocks of text, etc.
  • Cleanup Existing Module Code by adding Option Explicit, standardizing formatting, adding error handling to procedures that lack it, rename variable names to your convention, etc.
  • Deliver Modules with Line Numbers plus obfuscation
  • Find Unused Variables to pinpoint unnecessary code
  • Macro Recorder for playing back keystrokes while editing

Registered customers should have received email notification with download instructions of the update.