Upsizing very large Access tables containing lots of
text fields could, conceivably, overwhelm the 4GB limit on the SQL Server 2005 Express database file.
However, because an Access 2007 database is limited to 2GB, this is, at best, a remote possibility.
Figure 41-11 shows the upsized SQL Server database open in Management Studio Express. The
column properties of the Contacts table are displayed in the Summary tab of the Management
Studio interface, showing the data types the Upsizing Wizard selected for each field in the original
Contacts table.
FIGURE 41-11
Viewing the tables in the upsized database from within SQL Server Management Studio Express
NOTE
1263
Upsizing Access Databases to SQL Server 41
Summary
This chapter has surveyed the process of upsizing Access 2007 applications to SQL Server, using
the Access .adp data file format as upsized database output. SQL Server alleviates many issues
that have long vexed Access developers, such as database corruption, record lock contention, and
poor performance when more than a few users make simultaneous updates.
Pages:
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316