FMS Email Newsletter

Recent Newsletters

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

More Resources

Email NewsletterLatest Newsletter

Free Product Demos from FMSDemos

Microsoft Access Developer Help CenterMicrosoft Access Developer Help Center

Microsoft Access Query Help CenterMicrosoft Access Query Help Center

Microsoft Access SQL Server Upsizing CenterMS Access to SQL Server Upsizing

Microsoft Outlook TipsMicrosoft Outlook Tips

Free Technical PapersTechnical Papers

Tips and Techniques from FMSTips and Techniques

FMS videosVideos

 

FMS Email NewsletterNovember 2011

For Microsoft Access, SQL Server,
Visual Studio .NET, and VB6 Professionals


Luke Chung, FMS PresidentHi Everyone,

I've recently had several discussions with developers (not technology specific) about how they can be perceived as higher level professionals in enterprise environments.

One of the key steps is making sure you understand the larger needs of the organization. While it's nice to create solutions quickly and on your own, IT managers look beyond the current solution or technology to see how it will be supported and enhanced over time. Developers who create solutions that do not follow industry or organizational standards are a risk. While it may be personally satisfying to do things on your own, that's not a perspective shared or encouraged by organizations worried about what happens when you're no longer available to help. After all, they can all of a sudden become responsible for your work, and the next person may not be so pleased with your "creativity".

It's important to mitigate that risk by reaching out and using resources to help you be more productive. Adopt processes that address the long term requirements of a solution to support its entire lifecycle. This begins with understanding best practices for creating solutions and avoiding common mistakes. Within the application, there should be consistent coding, error handling and commenting standards, the use of source code libraries or shared code, etc. It should also include system documentation, version control, disaster recovery plans, quality assurance and test plans, deployment processes, etc.

We at FMS face these issues all the time, which directly resulted in the creation of many of our commercial products. Professional developers in enterprises use lots of 3rd party tools to be more productive. Take advantage of what we have to offer so your organization addresses these critical needs at a fraction of the cost of you building it yourself. In fact, using industry products and standards makes you more of a professional, not less. For more info and resources, FMS Blogblog on this topic with me.

We're very pleased to offer a free preview of Total Access Detective, our Microsoft Access database and object comparison wizard. We've created a new version for Microsoft Access 2010 with many new enhancements including support for both the 32 and 64 bit versions of Access 2010. We've also created an update for the Access 2007 version. Fully functional versions of both are available for your inspection through mid-December.

Updates for our Total Access Emailer and Total Visual CodeTools 2010 products were also released to existing customers, helping you be more productive than ever.

We're close to updating our remaining products for Microsoft Access 2010. Stay tuned.

All the best during this holiday season,

Luke Chung
President

Contents


Microsoft Access 2010Find differences between Microsoft Access databases and objects with Total Access DetectiveMicrosoft Access Object and Database ComparisonsDetect differences between Microsoft Access databases, object designs and data with Total Access Detective

Free Preview Versions of Total Access Detective for Microsoft Access 2010 (and 2007)

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

If you've ever wanted to try Total Access Detective, this is your chance! We are very pleased to offer a fully functional, Free Preview of Total Access Detective for Microsoft Access 2010 and 2007.  

Ever wonder what changed between your database versions or the difference between two similar objects or tables? Available as a Microsoft Access add-in, Total Access Detective lets you easily find differences between objects in your database. Quickly 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 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 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. Tell us how it works for you!

Free Preview Download


Product Updates for Total Access Emailer and Total Visual CodeTools

As part of our commitment to providing quality software, FMS provides the following update patches to existing customers free of charge. You must already own the existing product for these to work. Registered owners should have received email notification of the patches when they shipped.

Total Access EmailerTotal Access Emailer 2010 and 2007 Updates

Total Access Emailer lets you personalize emails from your Access database by using your list of contacts to send customized messages and attach filtered reports for each recipient.

Updates were released for the Microsoft Access 2010 version and the 12.6 version for Access 2007. New features include:

  • The ability to switch between formatted and raw HTML text when editing an email blast. This simplifies your ability to customize messages if you're not using an external HTML editor.
  • Improved handling of emails with different text and HTML versions
  • Better handling of embedded reports without NoData events

Total Visual CodeToolsTotal Visual CodeTools 2010 Update

Total Visual CodeTools helps you be a more productive programmer by helping you write new code and enhance existing VBA and VB6 code. Version 14.00.0024 was released with minor updates for the MsgBox Builder, Recordset Builder, and display of graphic images on the menus.


Microsoft Access 2010Product Catalog for Microsoft Access, Visual Basic 6, VBA, OfficeOnline Microsoft Access Product Catalog

Check out our product catalog which you can download from our web site with information on our Microsoft Access 2010 versions.

You can also download individual product fliers.


Microsoft Access 2010Microsoft Access Error Code and Description Reference

We've updated our Microsoft Access error reference with all the Microsoft Access 2010 codes and descriptions, and enhanced links to documents addressing them. The list is available in HTML pages and PDF reports.

There's also a MS Access database that includes the lists for Access 2010, 2007, 2003, 2002, and 2000, so you can see how descriptions changed over time.

This is one of many free resources in our Microsoft Access Developer Help Center.


FMS Professional Solutions GroupConsulting Services for the Education Community

University of PennsylvaniaThe University of Pennsylvania recently selected FMS for our custom software development services to enhance an existing database application.

Learn more about what we've done for our growing list of educational institutions.


Thank you for your continued interest and support!


________________

Microsoft Silverlight 5 Beta

Learn what's new

________________

Windows 8 Preview

Watch videos and experience many resources for the next version of Windows here.

Resources

Your Opinion Matters

Our newsletters are designed for you, the FMS customer. To help us provide better service, we encourage you to send us your suggestions and comments about "The Buzz", as well as our products and services.

We are constantly trying to improve the quality of our service to you, and your input is invaluable.

See something useful and you'd like to see more of it? Want more Microsoft updates?

Please let us know what you want to see. Simply email us with suggestions, comments, or requests.

Past Issues of the BUZZ

Have you missed a past issue of our Buzz email newsletter?

You'll find recent issues conveniently archived for easy retrieval. Get all the tips, news, product updates, and more!

All the news that's fit to email!

Microsoft Gold Certified Partner


Sign Up or
Change Your Address