We are very pleased to announce that Total Access Detective for Microsoft Access 2010 is now shipping with support for the 32 and 64 bit versions of Access 2010.

Ever wonder what changed between your database versions or the difference between two similar objects or tables? Total Access Detective is the premier program to detect differences between Microsoft Access databases, objects, code, and data.

Available as a Microsoft Access add-in, Total Access Detective lets you easily find differences between objects in your currently opened database. Easily find changes in your table and field definitions, object properties, controls, report sections, embedded macros, regular macros, modules, and data. The results are available to you in reports and on screen which can be copied or exported.

You can also compare any two databases to easily find exactly how they changed. Your databases can be an ACCDB, MDB or ADP database format. The new version lets you create separate databases for each comparison so you can easily manage multiple databases and changes over time.

We've added many new features to make Total Access Detective more powerful than ever:

• Supports Microsoft Access 2010, 32 and 64-bit versions
• Compares All Database Types Supported by Access 2010
• Compares the new Microsoft Access 2010 enhancements including new object properties, macro syntax, and VBA commands
• Performs Line-by-Line Comparisons of Embedded Macros
• Procedures that Did Not Change are Listed
• New Data Comparison Option to Ignore Case Differences
• When Comparing Modules, Optionally Ignore Blank Lines and Comments (also applies to text block comparisons)
• Exclude Properties from Comparison
• Create and Manage Multiple Database Comparison Results. You are no longer limited to one set of comparison results!
• Command Line Launching of Total Access Detective Can Now Specify Storage Database Name
• Improved User Interface with Office/Access 2010 Theme Support
• New Reports and Improved Selection Screen
• New User Manual and Context Sensitive Help

Manually comparing databases for design and data differences is prone to error. Discover why so many Microsoft Access professionals rely on Total Access Detective to improve their productivity by quickly identifying the changes in their work.

Total Access Components 2010 Ships with 32 and 64 bit ActiveX Controls

Create dazzling forms with Total Access Components, the only collection of custom controls designed specifically for Microsoft Access.

With little or no code, add advanced menus, rotated text, bitmap animation, resizer and splitter bars, progress meters, gauges, dials, sliders, spin buttons, pop-up notes, Windows dialogs, clocks, fancy buttons, borders, rotated tabs, cursors, etc. A sample database includes examples of every control and how to customize them.

The 2010 version is rebuilt using C++ version 10 and supports both 32 and 64 bit platforms without having to make any changes to your forms or code.

Total Access Components 2010 supports Access 2000 through 2010. It includes a royalty-free distribution license and a deployment program to easily distribute it to your users. Here are the new features. You can also download a free trial version.

Total Access Components 2007 is now shipping with support for Microsoft Access 2000 through 2007. Dazzle your users with amazing enhancements to your forms and reports using 30 custom controls designed exclusively for Access. Check out our product tour with examples of the features. For existing customers, here's a list of new features. Add animation, popup and icon menus, form resizer and splitter bars, data entry enhancements, custom cursors, simplified use of Windows API calls, and much more! Download the free trial version and see for yourself! 

Recently, we published an article describing how to Synchronize Two Related Subforms on a Microsoft Access Form. In that article, we mentioned when setting the master link field of a subform, you should always reference the control rather than the field name. We didn't mention why and received some inquiries, so this new article covers when and why that's so important. It includes a database with examples showing how a reference to the field instead of the control could cause users to not realize they're editing the wrong linked records, or adding and deleting records linked to the wrong master value. Read more in the article on why Microsoft Access Subforms Should Reference the Control Rather than Field for Master Link Fields