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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access