Splitting Databases into Tables and Other Objects
When earlier versions of Access ran in a multiuser environment, it was imperative to place the system's tables in one database and the rest of the system objects in another database. With Access 95 and the advent of replication, you could either split the tables from the other objects or use replication to deploy design changes without comprising live data. Access 2000 and Access 2002 take this a step further with the Access Data Project (ADP), in which tables, views, stored procedures, and data diagrams are stored in a SQL Server database or by the SQL Server 2000 Desktop Engine (formerly the Microsoft Data Engine, or MSDE). Forms, reports, macros, and modules are stored in the ADP file.
As mentioned ...
Get Alison Balter's Mastering Access 2002 Enterprise Development 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.
