WORKING WITH PROJECTS

You've probably already created Jet-centric Access applications consisting of two primary components: a front-end application database with queries, forms, reports, and modules, and a related back-end database with the data tables. In an Access Project, the front-end/back-end concept is employed but in a different model. In the front end (an Access .adp file) are forms, reports, and modules with VBA code. The back end (a SQL Server database) consists of the queries (called views), the data tables, and more application code in modules called stored procedures. Because the views and stored procedure code are in the back end, the processing of data retrieval and other data manipulation is optimized for maximum performance and ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.