Jan 19

Total Access Analyzer Versions X.8 Ship for Access 2003, 2002, and 2000

Microsoft Access Database DocumentationMicrosoft Access Database DocumentationMicrosoft Access Documenter

Total Access Analyzer is the world's most popular Access product. We recently shipped the Access 2007 version, and are now pleased to provide versions X.8 for Microsoft Access 2003, 2002, and 2000. The new versions are a significant upgrade and let you create and maintain Access solutions better than ever. Enhancements include the detection of new suggestions and performance tips including duplicate SQL string analysis across queries, record sources, and row sources. There's also a redesigned user interface, new reports, one click opening of the current object in design mode when viewing documentation and search results, Vista support, and much more. Click here for a complete list of new features in version X.8. We hope you like the results!

Jan 05

FMS Offers Access to SQL Server Migration Services

FMS has offered Access to SQL Server "upsizing" (aka conversion or migration) services for a number of years. We have been working with Microsoft to help customers convert their database applications from Access-based systems to (most typically) SQL Server and ASP.NET websites and web applications. We are one of the few companies in the world who are recognized by Microsoft as being experts at Access to SQL Server migration (see our whitepaper and partner link at the bottom of that page on the Microsoft website).

To kick off 2009, we are offering special rates on these services. Please contact us or give us a call at 703-356-4700 to find out how we can help your organization take the next step.

Dec 31

Security Patch for Excel Prevents Pasting into Access Tables

If you're used to pasting Excel spreadsheet data into an Access table, you may have encountered this error recently: The data on the Clipboard is damaged, so Microsoft Office Access can't paste it.  Maybe you thought there was something wrong with your spreadsheet, data, or memory. It turns out this is caused by a Microsoft Excel 2007 security patch that was released December 9th. Click on the link to learn about the issue and a workaround.

Dec 03

Finding Unused Objects and Code in Microsoft Access

If you're like most Microsoft Access users and developers, you've created databases with lots of objects. Over time, it's easy to lose track of which objects are still needed. A temporary query or report becomes permanent because you're not sure if it's being used by other objects. Same with macros and VBA code.  The annoying thing is that you may waste time maintaining objects and code that's not even being used. I've written a detailed article about the challenges of finding unused objects (you have to first determine where all objects are referenced before identifying unused ones) and one of the main benefits of using Total Access Analyzer.  http://www.fmsinc.com/MicrosoftAccess/UnusedObjects/FindingDeleting.html

Dec 03

White Paper: Application Development During Uncertain Times

The economy and financial markets are undergoing tremendous turmoil as this massive deleveraging unfolds. In response to discussions with our customers and the wider community, I published an article for things to consider when developing software applications during these challenging times. Minimize risk and maximize your potential by getting solutions into production quickly and let the market (users) decide what survives and dies. Application evolution and natural selection is most powerful during times like these. It's important to anticipate rather than be surprised by those forces. For more details, check out the paper (http://www.fmsinc.com/tpapers/budgets/ApplicationDev) which is referenced by Microsoft and other sites.

Wishing you the best and much success!