July 2009

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

Hi Everyone,

For our northern hemisphere customers, we hope you are enjoying a nice summer. This July in DC has been unbelievably mild and humidity free. But that doesn't mean we've been just enjoying the weather.

We're very pleased to release two more products for Microsoft Access 2007. Total Visual Agent and Total Access Detective are now shipping with full support for Access 2007, the new ACCDB database format, and many new features that our customers have requested and our innovative development team implemented. We think you'll be very excited by the results, which should make you more productive than ever.

With 11 of our 12 Access products completed for Access 2007, we only have Total Visual SourceBook remaining to complete our Total Access Ultimate Suite. We should finish that soon. Thank you for our patience and continued support.

Best wishes,

Luke Chung
President

Contents

• Total Visual Agent 2007 is Now Shipping
• Total Access Detective 2007 is Now Shipping with an Access 2003 Update
• Office 2007 Tip: Adding Command Buttons to the Quick Access Toolbar
• Update for Total Access Admin 2007
• Office 2007 Tip: Collapsing the Office 2007 Ribbon
• Purchase or Upgrade to Our Access 2007 Suites Now
• Access Tip: Layout View in Access 2007
• Follow FMS on Twitter and our Blog
• Microsoft SQL Server Database Consulting Services

Now Shipping: Total Visual Agent 2007

For optimal performance, Microsoft recommends you periodically compact and repair Access Jet databases (ACCDB and MDBs). You also need to create backups. Total Visual Agent lets you schedule and perform these repetitive tasks, including running a macro or command line, in a fully automated and audited manner. It can even run as an NT Service for additional security and email you if problems arise.

Total Visual Agent, the world's most popular maintenance scheduling program for Microsoft Access, is now available for Microsoft Access 2007. This is the seventh major release of Total Visual Agent and introduces many new enhancements. From supporting Access 2007 and the new ACCDB database formats, to enhanced Windows NT Service tasks, and additional support for ADPs, Total Visual Agent automates your maintenance chores better than ever.

Learn more about Total Visual Agent and how it can provide the professional system administration your applications need. A fully functional 30 day demo is available for you to manage all your Access databases on your machine and across your network.

Now Shipping: Total Access Detective 2007 and a New Version for Access 2003

Total Access Detective quickly determines what's different between two databases or two objects in one database. Eliminate the guesswork and see which properties, fields, controls, sections, macro lines, and VBA module code. You can even compare records between tables and create a new table by merging records between them.

In its sixth major revision since its debut in 1995, Total Access Detective is the premier difference detector for Access users and developers worldwide. This latest version includes many new features including:

• Support for Access 2007 support, the new ACCDB database format, multi-value fields, and all the new properties, macro actions, and VBA syntax
• Enhanced comparisons of Access Data Projects (ADPs)
• Data comparison between queries
• Data comparison between tables without identical field names
• Optionally ignore small data differences between numerical fields
• Command line automation for database comparisons
• New reports and output to PDF and XPS formats
• View the last results for two object comparisons
• And many more features

For our Access 2003 customers, Version 11.7 is now available with many similar enhancements. Existing customers can upgrade for a nominal fee.

Tip for Office 2007: Adding Commonly-used Command Buttons to the Quick Access Toolbar

In Microsoft Office 2007 programs (Access, Word, Excel, PowerPoint, etc.) the Quick Access toolbar in the upper left corner offers shortcuts to several commonly-used toolbar buttons or commands. By default, it just shows Save, Undo, and Redo. However, you can customize this to add commands that you use often.

Total Access Admin 2007 Update

Total Access Admin lets you monitor Access databases in real time to see who's entering and exiting them.

As part of our commitment to quality software, FMS regularly releases product update patches to add new enhancements and resolve known issues. Most recently, we have released an update for Total Access Admin 2007 (version 12.00.0134).

This update is available free of charge to registered owners of Total Access Admin 2007, version 12.0. Notification and download instructions for receiving the patch were emailed to registered owners. If you did not receive instructions, please contact us so we can update your information.

Tip for Office 2007: Collapsing the Office 2007 Ribbon to get more space in your program

When moving from earlier versions of Microsoft Office programs (Access, Word, Excel, PowerPoint, Outlook) to Office 2007, the new Ribbon can be very difficult to get used to. One common complaint is that it takes up so much space. However, did you know that the ribbon can be easily collapsed to give you extra vertical space?

Purchase or Upgrade to Our Access 2007 Suites Now

Because we're down to upgrading one remaining product for Microsoft Access 2007, and in response to existing Suite owners, we are offering our Access 2007 suites now.

Purchase either Total Access Developer Suite 2007 or Total Access Ultimate Suite 2007 now and receive all the shipping versions of the products, plus the remaining product, Total Visual SourceBook 2007, when it's available. In fact, you'll get Total Visual SourceBook 2003, which is compatible with 2007, and then the upgrade with the full 2007 code supplement when it's released. Email us for pricing or call us to place an order.

For more information on all our upcoming Access 2007 related products, visit Schedule for Microsoft Access 2007

Tip for Access: Layout View in Microsoft Access 2007

Designing forms and reports impacts the overall look and feel of the application. Microsoft Access 2007 comes with many new features to make your Access application more impressive. One of the new features in Microsoft Access 2007 is Layout View, which allows users to design forms and reports more easily. To turn on this feature, click the Office button and then open Access Options.

Follow FMS on Twitter!

Follow FMS on Twitter! We are now tweeting about topics that should interest subscribers of our blog, so tune in. There are a lot of great Twitter clients, including Tweet Deck, that you can use if you don't already have one installed.

And don't forget about our blog and RSS feed!

Microsoft SQL Server Database Custom Consulting Services

As you may know, our Professional Solutions Group offers custom Microsoft ASP.NET solutions, but we also have expertise providing Microsoft SQL Server consulting services for a variety of clients across the private and public sectors.

Please contact us for a free assessment of your organization's database requirements.

Thank you for your continued interest in FMS, Inc.
We look forward to hearing from you!

Sincerely,

Your Friends at FMS

TechNet Evaluation Center Explore and evaluate great Microsoft products for your company Register for the free download and then check your email for convenient resources that enhance your evaluation experience. ________________ Microsoft Office 2007 Service Pack 2 Released Details of the update are in this knowledgebase article. Existing owners can download SP2 for free from Microsoft. ________________ Bing: Microsoft Search Get the right information to make the right decisions. Try it today ________________  Silverlight and Expression Portal Find out what is new with Silverlight, Expression, and how they can work better together.

Resources Home Blog Twitter Demos Newsgroups Book Recommendations Technical Papers Training Videos 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 and give us your suggestions, comments, or requests.

Past Issues of the BUZZ Archived for You Have you missed a past issue of the popular FMS "The Buzz" email newsletter? You'll find recent past issues conveniently archived for easy retrieval. Get all the tips and product news, plus bug fixes and more! Get all the news that's fit to email!

Sign Up or
Change Your Address