All of the tables, queries, and other data-oriented objects are contained within
the SQL Server database. An Access .adp file is not much more than an interface to the SQL
Server database and contains the forms, reports, VBA code, and other user-interface components.
The good news is that if you??™re moving from an existing Access front end to SQL Server, you don??™t
have to build these objects from scratch. The Access Upsizing Wizard does most of the work for
you, preserving the work you??™ve already invested in the user interface of your Access application.
Using linked SQL Server tables in an Access front end can be an acceptable solution for many
small-workgroup environments. However, for environments with large numbers of users or where
large volumes of data are processed, you need a solution that utilizes client-server architecture in
both the front-end and back-end databases.
Although this chapter focuses on upsizing an Access database to SQL Server, a very
common technique for using SQL Server data in an Access application is to use ODBC
to link to SQL Server tables.
Pages:
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294