Part VI: Access as an Enterprise Platform
1240
Figure 38.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 38.11The tables in the upsized database from within SQL Server Management Studio Express
Summary
This chapter has surveyed the process of upsizing Access 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.Furthermore, upsizing to SQL Server immediately makes Access data accessible to any application
connecting to SQL Server, including Web sites and Microsoft SharePoint Services. It’s hard to over-
emphasize how important this aspect of the upsizing process is to Access developers. The data that
your users input into their desktop Access applications is instantly accessible anywhere in the