April 2011

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

Hi Everyone,

We hope you took advantage of the preview version of Total Access Emailer for Microsoft Access 2010. We appreciate the feedback we received and are pleased to announce that we're now shipping Total Access Emailer 2010 and updated X.6 versions for earlier versions of Access. If you are seeking to leverage the power of Access with email, Total Access Emailer is for you. Free trial versions are available.

We're also pleased to announce the creation of our FMS Facebook page. "Like" us to get our latest information directly in Facebook. You'll also be able to post comments.

In this newsletter we provide a new paper on using Windows Terminal Server and RemoteApp to web enable Microsoft Access and all your Windows applications in a controlled manner. We're also reporting a new complication if you've installed Windows 7 Service Pack 1.

Meanwhile, our Sentinel Visualizer program is gaining traction with organizations who are using its advanced data analytics for some really interesting solutions.

I'll be speaking at some upcoming events in Denver, Colorado and Portland, Oregon in the near future, and hope to see you there. All the best!

Luke Chung
President

Contents

• Total Access Emailer for Microsoft Access 2010 is Shipping
• Using Terminal Services and RemoteApp to Extend Windows Applications Over the Internet
• Join us on Facebook
• Meet Luke Chung at Access Events in Denver, CO and Portland, OR
• Microsoft Windows 7 Service Pack 1 Breaks Backward Compatibility for ADO
• Free Microsoft Access Book Offer
• Sentinel Visualizer Provides Law Enforcement and Investigative Solutions

Total Access Emailer for Microsoft Access 2010 is Shipping

Total Access Emailer is the most popular Microsoft Access email program. Running as an add-in, it lets you easily send personalized emails using the information in your database. From using fields in the subject and body of the message, to attaching PDF reports filtered for each recipient, you'll find that Total Access Emailer revolutionizes the way you communicate with your contacts. Any table or query can be the data source for your emails which can be in text or HTML format. We can even automatically include graphics in your HTML emails or let them reference a public site.

We are very pleased to announce Total Access Emailer for Access 2010. Enhancements include support for Access 2010, 32 and 64 bit, compressing all your attached files into one zip file with optional password, international extended character support, a new Code Generator, additional programmatic interfaces, and many more new features. An X.6 upgrade version for Access 2007 and earlier versions also available. Download the Free Trial.

Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet

Read our new paper on using Terminal Services and RemoteApp with Microsoft Access.

One of the features of Microsoft Windows Server that is increasingly popular over the last few years is the Terminal Server and more recently RemoteApp. With few exceptions, most Windows applications work within a Terminal Server environment. By doing so, your investment in existing applications, and the power of Windows desktop features and interoperability can be exposed over the Internet.

This is particularly powerful for database applications such as Microsoft Access since it eliminates the need to send large amounts of data over the Internet for Access to process and users do not need to install Access on their machine. With RemoteApp, you can set up a terminal server experience where your users can only run your application without running other applications or browsing your network. Easily web enable all your desktop applications.

Contact our Professional Solutions Group to learn more.

Join us on Facebook

We are delighted to offer a better way for you to stay informed of our latest news, simply "Like" us on Facebook

Meet Luke Chung at Up Coming Access Events

Luke Chung Presenting at the Denver Area Access User Group April 5th

FMS President Luke Chung will be the guest presenter at the April 5th meeting of the Denver Area Access User Group. He'll be discussing Microsoft Access 2010, FMS products for Microsoft Access, and all things Access. See you there!

DAAUG Meeting
April 5, 2011 from 6 to 9PM
Microsoft USA - Rocky Mountain District
7595 Technology Way
Suite 400 (4th Floor)
Denver, CO 80237

Luke Chung Speaking at Portland Access User Group Conference in May

FMS President Luke Chung will be attending and speaking at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group. Join him and other guest speakers including Alison Balter from InfoTech Services Group Inc., Armen Stein from J Street Technology, and Kevin Bell from Microsoft.

Luke will be speaking on the following topics:

• FMS Products for Microsoft Access Developers and How they Make You Money
• Microsoft Access and Azure: Working in the Cloud
• Microsoft Access Disaster Recovery Plans

For complete details visit PAUG 2011 Database Designer Conference and see you there May 14-16

Microsoft Windows 7 Service Pack 1 Breaks Backward Compatibility with ActiveX Data Objects (ADO)

The recent release of Windows 7, Service Pack 1 (and Windows 2008 R2) breaks backward compatibility for Microsoft ActiveX Data Objects (ADO). That means if your .NET, Visual Basic 6, VBA/Office, C++ or other program includes an ADO library reference, and you compile your application or COM object on a Windows 7 SP1 machine, it will not run when deployed to an earlier environment containing the existing ADO object. Ouch!

For more information, visit our blog on Microsoft Windows 7 Service Pack 1 Breaks Backward Compatibility with ActiveX Data Objects (ADO)

Free Microsoft Access Book Offer

Congratulations to our friends and Microsoft MVPs, Arvin Meyer and Douglas Steele who recently published Microsoft Access Solutions: Tip, Tricks and Secrets from Microsoft Access MVPs. Filled with quick ways to improve your productivity, it's available on Amazon.com.

Even better, we are pleased to offer a limited quantity of this book for FREE (a $50 value). Thanks to a special arrangement with the authors and their publisher, Wiley, purchasers of any of our Access product suites can receive a complimentary copy of this book.

Free book offer details..

Sentinel Visualizer Provides Law Enforcement and Investigative Solutions

Sentinel Visualizer from the FMS Advanced Systems Group is our commercial, off-the-shelf product that brings the power of data visualization, link analysis, geospatial, timeline, Social Network Analysis (SNA) to your data. Written in .NET and SQL Server, we recently released version 4.6 with new features including Google Earth integration to empower analysts to better understand hidden relationships in their data.

Read what some of our international customers are saying:

"We use Sentinel Visualizer practically every day, it’s made an enormous impact on our ability to effectively visualize and analyze our data sets."
Phill Arnold with Counterfeiting Intelligence Services (CISAA) in Australia

"Without Sentinel Visualizer it would have been a daunting task or even impossible to break down the data and reveal the criminal networks behind one of the largest frauds in the history of the European Union (EU)."
BBo Elkjær, award winning journalist for Ekstra Bladet, Denmark

Thank you for your continued interest and support!

Sign Up or
Change Your Address