Technical Papers

FMS Technical papers and related resources were created by FMS personnel. Many were published or presented at conferences and/or published in industry journals.

• General Papers
• Videos
• Current Access Papers
• VB6/VBA Papers
• SQL Server Papers
• Visual Studio .NET Papers
• Legacy Access Papers
• Redistributing FMS Papers

Additional Tips and Techniques

General Papers

• Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update Requires Fixing NEW!
• Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers
• Financial Reporting for Startup and Ecommerce Organizations
• Application Development During Uncertain Times

Videos

• Let's Talk about Software Consulting as a Business
  For the Tech Ed 2009 Conference, Microsoft selected FMS President Luke Chung and two other entrepreneurs to discuss challenges with running their software consulting firms over the past two decades.
• The World Turned Upside Down: Development Strategies for Lean Times
• Migrating Your Data Tier to SQL Server: Strategies for Survival
• The FMS Story:
  Surviving Uncertain Times: An Interview with Luke Chung
• Microsoft Access Database and Migration Challenges
  Watch this Microsoft interview and read more about Migrating Microsoft Access Databases to SQL Server
• Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

Overview of All Videos

Current Microsoft Access Papers

• Microsoft Access Query Sorting on Multiple Date (or Numeric) Fields Containing Blank Values NEW!
• Data Entry and Navigation Shortcut Keys for Microsoft Access REVISED!
• Taking Over an Inherited Microsoft Access Database Application
• Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet
• Deploying Microsoft Databases Linked to a SQL Azure Database to Users without SQL Server Installed on their Machine
• Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud)
• Microsoft Access Query Tips and Techniques REVISED!
• This Recordset is not updateable: Dealing with non-updateable queries in Microsoft Access
• Query Tip: Finding Records in One Table but Not Another with “Not In” Queries
• Delete Query and SQL Syntax in Microsoft Access
• Update Query and SQL Syntax in Microsoft Access
• Top Features of Microsoft Access 2007 That Aren't Available in Prior Versions
• Finding and Deleting Unused Microsoft Access Objects and Code
• Database Evolution: Microsoft Access within an Organization's Database Strategy
• Microsoft Access Performance Tips to Speed Up Access Databases
• Complete Microsoft Access Error Number and Description Reference
• Creating Monthly Summary Reports without Code by Creatively Using Microsoft Access Crosstab Queries
• Microsoft Office Access 2007 Form Tips
• Form Tips and Avoiding Common Mistakes
• Microsoft Access and SQL Server Data Normalization Tips
• Microsoft Access Data Normalization Fundamentals
• Object Cross-Reference and Eliminating Unused Objects
• Field Consistency Tips
• Report Tips and Avoiding Common Mistakes
• 17 Steps to Better VBA Code
• When Access Math Doesn't Add Up
• Internationalizing Access Applications
• Display Self-Relational Data in a Microsoft TreeView
• Get Better Requirements Before Development
• How Linking Tables at Runtime Affects ActiveX on Forms and Reports

Visual Basic 6 (VB6) and VBA Papers

• Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic 6 (VB6)
• 17 Steps to Better VBA Code

SQL Server Papers

• When to Migrate from Microsoft Access to Microsoft SQL Server, as seen on Microsoft MSDN, written by FMS
• Migration for Microsoft Access to SQL Server (on the Microsoft web site)
• Evolving Microsoft Access Applications to Microsoft SQL Server
• Strategic Management of Tactical Assets
• A look back over the past 10 years of Microsoft SQL Server on Windows
• Choosing an Edition of SQL Server 2000
• Microsoft SQL Server 2000 Enterprise Edition
• Database Evolution: Microsoft Access within an Organization's Database Strategy

Visual Studio .NET Papers

• Designing Commercial Web Services: Security and Flexibility with the .NET Framework

Legacy Access Papers

Access 97

• Use Classes to Enhance List and Combo Boxes in Access 97

Access 95

• Access 95 VBA Internals
• Building Microsoft Access 95 Libraries and Wizards
• DAO Advanced Programming
• Data Access Objects Version 3 - An Evolutionary Upgrade

Redistributing FMS Papers

FMS makes many resources available on our web site for the development community. As an FMS customer, you are welcome to provide links to our web site so that others within your organization can benefit from our research. By creating a link to a specific white paper or free utility, you ensure that you always have access to the latest version. If you wish to redistribute our resources, please be aware of the following requirements:

1. You may redistribute our whitepapers in printed or electronic form as long as the whitepaper is distributed in its entirety with no modifications. Additionally, all FMS copyright information must be included in the document and reference back to the original URL provided.
2. Non-whitepaper materials, including, but not limited to free utilities, source code, and product updates may not be redistributed in any form without the express written permission of FMS Inc.
3. You are welcome to use the source code and examples provided in the papers for your applications provided you've signed up for our monthly email newsletter and maintain your current contact information (click here).

Please note that we are constantly revising material to bring the latest news and results of our research process. This means that the free resources on our web site are updated frequently. You should check our site often to get the latest version of these resources.