Special Edition Using Microsoft® Office Access 2003

Chapter 22. Upsizing Jet Applications to Access Data Projects

In this chapter

• Taking a Hard Look at the Upsizing Process

• Preparing to Upsize Your Jet Applications

• Upsizing with the Trial-and-Error Approach

• Comparing ANSI-92 SQL, T-SQL, and Jet SQL

• Emulating Jet Crosstab Queries with T-SQL

• Running the Jet Crosstab Upsizer

• Securing Projects with the MSDE 2000 Login/User Tool

• Troubleshooting

• In the Real World—Strategic or Not?

Taking a Hard Look at the Upsizing Process

Upsizing a Jet application to an SQL Server and an Access project is a drastic operation. The Upsizing Wizard banishes all vestiges of Jet from your application. As a general rule, the probability of initial upsizing success is inversely proportional to the size and complexity of your Jet-based ...