Chapter 40 discusses this process and shows how to access SQL Server
data from a standard Access 2007 .accdb file. The .adp file created by the Upsizing Wizard is actually
an Access 2000 format data file, but it features all of the user-interface enhancements seen in the
.accdb data file type.
Upsizing Access and the Upsizing Wizard
Today, many organizations are becoming more and more dependent on their database applications
to manage everyday business operations, and these applications are growing both in volume of
data and number of users. Applications that you may have developed using Microsoft Access even
NOTE
ON the CD-ROM
1250
Access as an Enterprise Platform Part V
in the past year or two may be starting to strain the organization??™s network. At the same time,
client-server databases like SQL Server are becoming more popular, even with smaller businesses,
because these databases become easier to install, use, and maintain.
You may be among those who have been recently advised of a new mandate that all new applications
must conform to client-server technology only: No file-server database management allowed.
Pages:
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295