21. Linking Access Front Ends to Access and Client/Server Tables

A single .accdb file that contains Access application objects (forms, reports, macros, and VBA code modules) and Access data objects (tables and queries) is one of Access’s strongest selling points. Other desktop database management applications—such as Visual FoxPro and Visual Basic—require multiple files for a single database application. The obvious advantage of a single .accdb file for a complete Access application is simplicity. You can deploy your application by copying its .accdb file to another computer that has Access 2010 installed.

Note

image

An SQL Server instance is simply ...

Get Microsoft® Access® 2010 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.