Chapter 20. Advanced Data Operations

IN THIS CHAPTER

Creating Linked Tables 313

Data Definition Language 315

Schema Recordsets 317

Subqueries 319

Creating Linked Tables

As you continue to develop your database you may find yourself in a challenging situation. The challenge I am referring to is created when you develop your user interface (UI) in one database file, and then you are faced with integrating those changes into your “released” application.

This challenge is overcome with the implementation of a split configuration. When implementing a split configuration, you create one database that stores all your tables and relationships (or your base data schema). The database with your tables is called the back end (BE). Then you create an application ...

Get Microsoft® Office Access 2007 VBA 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.