O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required