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.
- Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update Requires Fixing
- Financial Reporting for Startup and Ecommerce Organizations
- Application Development During Uncertain Times
- Get Better Requirements Before Development
- Tips and Techniques for Setting Up Remote Desktop Connections and Using Multiple Displays
- Microsoft Azure Security Holes with SQL Server Databases NEW!
- Converting Microsoft Azure SQL Server Databases to SQL Elastic Pools
- Monitoring SQL Server Usage on Microsoft Azure and Setting DTU Limits
- 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 Azure Development and Hosting Services
- Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers
- RemoteApp and Microsoft Access Database Applications NEW!
-
Let's Talk about Software Consulting as a Business
For the Tech Ed 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
- Microsoft Access Form Tip: Copy and Paste a Command Button without Losing its Picture NEW!
- Microsoft Access Append Query Examples and SQL INSERT Query Syntax
- Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History REVISED!
- Microsoft Access Query Tip to Convert a Text Field to Proper Case
- Microsoft Access Query Sorting on Multiple Date (or Numeric) Fields Containing Blank Values
- Data Entry and Navigation Shortcut Keys for Microsoft Access
- 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
- Microsoft Access Query Tips and Techniques
- 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
- When Access Math Doesn't Add Up
- Internationalizing Access Applications
- Display Self-Relational Data in a Microsoft TreeView
- How Linking Tables at Runtime Affects ActiveX on Forms and Reports
Microsoft Jet Database
- Microsoft SQL Server Database Users and Permissions NEW!
- 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)
- SQL Server Express Editions and Downloads REVISED!
- 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
- Database Evolution: Microsoft Access within an Organization's Database Strategy
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:
- 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.
- 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.
- 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.
Latest Newsletter
Demos
Microsoft Access Developer Help Center
Microsoft Access Query Help Center
MS Access to SQL Server Upsizing
Microsoft Outlook Tips
Technical Papers
Tips and Techniques
Videos
Connect with Us
Email Newsletter
Developer Team Blog
Facebook
Twitter
Support ForumAdditional Resources
Book
Links to Related Sites
My FMSThank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.
Darren D.
All Our Microsoft Access Products
