Microsoft Access Database and Migration Challenges Video

MSDN Channel 9MSDN Channel 9/ARCast.TV

Interview of Luke Chung

Microsoft Access to SQL Server VideoMicrosoft’s Dr. Zhiming Xue interviews Luke Chung on dealing with Microsoft Access Database solutions and the challenges project teams face when migrating them to more scalable platforms. Luke Chung, founder and president of FMS, shares his view on Microsoft Access database solutions:

  • Where they fit well
  • What challenges users and developers often face in creating and maintaining them
  • How they evolve from standalone desktop solutions to integrating with web-based and SharePoint centric solutions.

He further explains the primary reasons why some Access database solutions migrate to SQL Server based solutions, different approaches for carrying out migrations, and how to get started with the migration process when a large number of Access databases are involved.

Watch the Video (22 minutes)

Additional Resources

Strategic Overview

SQL Server Express

SQL Azure Cloud

What it Means to Information Workers

Link Microsoft Access to SQL Azure Databases

Deploy MS Access DBs linked to SQL Azure

Eliminate SQL Azure Security Holes

Monitor SQL Server Usage and DTU Limits on Azure

Convert Azure SQL Server to Elastic Pools

SQL Server Tips

Database Users and Permissions

Database Backup and Restore on Network

AM/PM Date Time Format

Get Date Portion


Running Total


Migrate Your Data Tier to SQL Server: Strategies for Survival

Microsoft Access Database and Migration Challenges

Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

Visual Studio LightSwitch

LightSwitch Introduction

Comparison Matrix


Microsoft SQL Server Consulting Services

Visual Studio .NET programmers for web development

General Microsoft Access consulting services

Additional Resources

Microsoft Access Help

Microsoft Access Developer Help Center

MS Access Developer Programming

More Access and SQL Tips

Technical Papers

Microsoft Access Tools

Connect with Us


Free Product Catalog from FMS