FMS Technical papers were written by FMS personnel. Many were published or presented at conferences.

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

Videos

• Microsoft TechEd Orlando NEW!
  Luke Chung, FMS President, participated in a panel discussion of: Are we there yet? Successfully navigating the bumpy road from Access to SQL Server. Watch the Video (49 minutes)

Current Microsoft Access Papers

• Microsoft Access Query Tips and Techniques REVISED!, by Luke Chung
• Microsoft Access Performance Tips to Speed Up Access Databases, by Dan Haught and Luke Chung REVISED!
• Complete Microsoft Access Error Number and Description Reference,
  by Luke Chung NEW!
• Creating Monthly Summary Reports without Code by Creatively Using Microsoft Access Crosstab Queries, by Luke Chung NEW!
• Microsoft Office Access 2007 Form Tips, by Luke Chung
• Form Tips and Avoiding Common Mistakes, by Luke Chung
• Database Evolution: Microsoft Access within an Organization's Database Strategy, 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
• Create Personalized Splash Screens for Access, by Steve Fisher
• Non-Updateable Queries and the Use of Temporary Tables, 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
• Taming the Ugly Beast, by Steve Clark
• Access Table Relationships, by Steve Clark
• Display Self-Relational Data in a Microsoft TreeView, by Steve Clark
• Display Self-Relational Data in a Microsoft Visio, by Steve Clark
• Manage Look-Ups in Access, by Michelle Jean
• Get Better Requirements Before Development, by Steve Clark
• How Linking Tables at Runtime Affects ActiveX on Forms and Reports, by Troy Munford

VB/VBA Papers

• Access VBA/VB Debugging Tips and Techniques, by Luke Chung
• 17 Steps to Better VBA Code, by Dan Haught
• Create a Page Indicator Component, by Rob Mastrostefano

SQL Server Papers

• When to Migrate from Microsoft Access to Microsoft SQL Server
  As seen on Microsoft, written by FMS
• Microsoft Access or SQL Server: What's Right in Your Organization?
  As seen on Microsoft, written by FMS
• Evolving Microsoft Access Applications to Microsoft SQL Server, by Dan Haught
• Strategic Management of Tactical Assets, By Dan Haught
• Microsoft SQL Server Gets Extensible with XML, by Jerry Kelly
• 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.