We wish the very best to you and your families during this holiday season.

As we wrap up the year, we're pleased to announce the release of Total Access Components 2010, our collection of 30 ActiveX controls designed specifically for Microsoft Access, now supporting both 32 and 64 bit platforms.

We'd also like to thank the many people who tried the preview version of Total Access Detective 2010. The feedback was overwhelmingly positive, and we're going through the final paces to ship it by early January.

Be sure to Like our Facebook page to get the latest information on our product releases, tips, and other news related to helping you be more productive.

On behalf of everyone at FMS, have a joyous and prosperous new year!

Luke Chung
President

Contents

• Total Access Components for Microsoft Access 2010 Ships
• Total Access Detective for Microsoft Access 2010 (2007 and 2003) Shipping Soon
• Windows 7 SP1 Breaks ADO Compatibility
• Popular Blog Topics
• Microsoft Access 2010 Issue with Hotkeys in Tabs
• Using the Social Network Analysis Features in Sentinel Visualizer for Business Development
• In Memory of Michael Groh

Total Access Components 2010 Ships with 32 and 64 bit 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 Detective for Microsoft Access 2010, 2007, and 2003

Total Access Detective is the world's premier program for detecting differences between Microsoft Access databases, objects, code, and data.

We introduced the preview version for Total Access Detective 2010 last month and expect to ship by early January. We're also releasing update versions for MS Access 2007 and 2003.

Watch our Blog, Facebook page, or Twitter feed for the release announcement.

Windows 7 SP1 Breaks ADO Compatibility

Windows 7 SP1 installs a modified ADO component which breaks backward compatibility. Any compiled application using ADO built on SP1 won't run on earlier platforms. The result is forcing developers using Windows 7 to not install SP1, or maintaining separate build machines with a legacy operating systems.

We blogged about this in March when customers first encountered this in our Microsoft Access add-ins. Microsoft has finally committed to fixing this but it won't happen until the new year:
A better solution for the Windows 7 SP1 ADO GUID changes.

Popular Blog Topics

In addition to our blog on the ADO topic, here are some other blogs that people have found popular:

• Microsoft Access 2010 Service Pack 1 VBA Project Compatibility Issues
• Microsoft Access Database Scalability: How many users can it support?
• How to Be Treated as a Professional Developer in Enterprises
• Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet
• Microsoft Access and Cloud Computing with SQL Azure Databases

We welcome your feedback on our blog.

Microsoft Access 2010 Issue with Hotkeys in Tabs

If you've seen different behavior with hotkeys in tabs on forms in Microsoft Access 2010, you may have experienced what our friend Joe Anderson describes in this MSDN thread:

Problem with access keys and tab controls in Access 2010

Using the Social Network Analysis Features in Sentinel Visualizer for Business Development

Our data analysis product, Sentinel Visualizer from our Advanced Systems Group, revolutionizes the way people analyze data to find hidden relationships among people, places, and events. Applying visual link charts, geospatial mapping, timelines, and social network analysis (SNA) metrics, this product is finding commercial interest beyond its traditional law enforcement and academic communities.

Even lawyers are using SNA for their business development activities. Our Dan Wasser recently contributed a chapter on Visualizing Networks for Practice Development and Case Management.

Interested in learning more about displaying complex relationships beyond rows and columns? Visit the FMS Advanced Systems Group web site and contact us for a trial version.

In Memory of Michael Groh

During this holiday season, it's nice to remember those who have blessed us over the years.

Longtime friend and supporter for FMS, Michael Groh passed away in November after a brave battle against pancreatic cancer. Many of you may know Mike from the earliest days of Access. He was the editor of the Access Advisor magazine, book author, conference speaker, and application developer. He was an all around good guy with a keen appreciation for creating real-world solutions.

We miss your smiling face and uplifting spirit. Condolences to your family and friends. Obituary.

Thank you for your continued support! Happy Holidays!

Sign Up or
Change Your Address