Partial Replication
Version 3.5 of the Microsoft Jet database engine allows users to replicate portions of a table instead of the whole table (only row restrictions are permitted, not columns). There are two types of filters used in a partial replica — Boolean and relationship. Boolean filters select only rows that meet a certain criteria to limit the rows in a table that are replicated. DAO represents this filter with the ReplicaFilter property on a CdbTableDef. Relationship filters enforce a relationship between partially replicated tables to limit the rows in a table that are replicated. With DAO, you can set the PartialReplica property on a CdbRelation which allows that CdbRelation to be used in partial replication.
New CdbRecordset Type
In DAO 3.5, dbOpenForwardOnly is a new Type argument for the OpenRecordset method. This new CdbRecordset type behaves in the same way as a DAO 3.0 snapshot-type CdbRecordset opened with the dbForwardOnly option.
Run-time Registry Override
The new SetOption method allows you to override Microsoft Jet Registry settings at run time. This lets you fine tune Microsoft Jet query performance, timeout delays, and so on.