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 Azure and Cloud Computing...What it Means to Me and Information Workers, by Luke Chung NEW!
• Financial Reporting for Startup and Ecommerce Organizations, by Luke Chung NEW!
• Application Development During Uncertain Times, by Luke Chung

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

• Deploying Microsoft Databases Linked to a SQL Azure Database to Users without SQL Server Installed on their Machine NEW!
• Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud) NEW!
• This Recordset is not updateable: Dealing with non-updateable queries in Microsoft Access, by Luke Chung REVISED!
• Query Tip: Finding Records in One Table but Not Another with “Not In” Queries NEW!
• Delete Query and SQL Syntax in Microsoft Access NEW!
• Update Query and SQL Syntax in Microsoft Access NEW!
• Top Features of Microsoft Access 2007 That Aren't Available in Prior Versions NEW!
• Finding and Deleting Unused Microsoft Access Objects and Code, by Luke Chung NEW!
• Microsoft Access Query Tips and Techniques, by Luke Chung REVISED!
• Database Evolution: Microsoft Access within an Organization's Database Strategy, by Luke Chung
• Microsoft Access Performance Tips to Speed Up Access Databases, by Dan Haught and Luke Chung
• Complete Microsoft Access Error Number and Description Reference,
  by Luke Chung
• Creating Monthly Summary Reports without Code by Creatively Using Microsoft Access Crosstab Queries, by Luke Chung
• Microsoft Office Access 2007 Form Tips, by Luke Chung
• Form Tips and Avoiding Common Mistakes, by Luke Chung
• Microsoft Access and SQL Server Data Normalization Tips, by Luke Chung
• Microsoft Access Data Normalization Fundamentals, by Luke Chung
• Object Cross-Reference and Eliminating Unused Objects, by Luke Chung
• Field Consistency Tips, by Luke Chung
• Report Tips and Avoiding Common Mistakes, by Luke Chung
• 17 Steps to Better VBA Code, by Dan Haught
• When Access Math Doesn't Add Up, by Luke Chung
• Internationalizing Access Applications, by Dan Haught
• Display Self-Relational Data in a Microsoft TreeView, by Steve Clark
• Get Better Requirements Before Development, by Steve Clark
• How Linking Tables at Runtime Affects ActiveX on Forms and Reports, by Troy Munford

VB6/VBA Papers

• Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic 6 (VB6), by Luke Chung REVISED!
• 17 Steps to Better VBA Code, by Dan Haught

SQL Server Papers

• When to Migrate from Microsoft Access to Microsoft SQL Server
  As seen on Microsoft, written by FMS
• Migration for Microsoft Access to SQL Server (on the Microsoft web site)
• Evolving Microsoft Access Applications to Microsoft SQL Server, by Dan Haught
• Strategic Management of Tactical Assets, By Dan Haught
• 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, by Luke Chung

Visual Studio .NET Papers

• Designing Commercial Web Services: Security and Flexibility with the .NET Framework, by Dan Haught.

Legacy Access Papers

Access 97

• Use Classes to Enhance List and Combo Boxes in Access 97, by Jim Ferguson

Access 95

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

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.