Microsoft® Access® 2010 In Depth

28. Upsizing Access Applications to Access Data Projects and SQL Azure

Upsizing an Access application to an SQL Server 2005 SP3 [Express] or later (SSX) back-end database and an Access data project (ADP) is a drastic operation. The Upsizing Wizard banishes all vestiges of Access data objects—Tables and QueryDefs—from your application. As a general rule, the probability of initial upsizing success is inversely proportional to the size and complexity of your .accdb-based Access application. If you’ve designed your initial Access applications with upsizing in mind, the likelihood of upsizing success greatly increases. It’s a safe bet, however, that only a small percentage of existing Access applications were developed with ease of upsizing as a ...