O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

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

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

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