O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required