If you read Microsoft Migration White Paper, you may think that migrating an Access application to SQL Server is a straightforward process. Unfortunately, real life is sometimes more complex that the cases the white papers describes.
This series of article will deal with all the issues of a migration from Access to SQL Server, with the front-end remaining in Access, in order to minimize the migration time and cost.
All the articles are based on real life migrations I've done these past years with different versions of Access and SQL Server, and on the book I wrote in French that has been published by Microsoft Press France this last spring.
These different articles will focus on the following subjects:
To keep you waiting a few days, I advice you to download and read the MS Migration White Paper at http://www.microsoft.com/sql/techinfo/accessmigration.htm.