Microsoft KB Archive/140128

= What Is New and Obsolete with DAO in MS Access 95 =

Article ID: 140128

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q140128



SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills

The Microsoft Jet database engine version 3.0 has many functional improvements over earlier versions. This article discusses the enhancements made to data access objects (DAO), the programmatic interface provided by the Microsoft Jet database engine for accessing and manipulating data in databases.



New Features
The following is a list of new methods and properties for individual data access objects.

DBEngine Object:
 * Because .INI files are no longer used by the Jet database engine, the INIPath property stores a path to the system registry.

Workspace Object:
 * The new Source argument (also known as the Connect string) enables you to specify a password to open a password-protected database in a workspace.

Database Object:
 * There are five new properties for database replication: Replicable, DefaultPartner, ReplicaID, DesignMasterID, and KeepLocal.
 * The new Synchronize method enables you to use replication to synchronize the current database with a replica database.
 * The new MakeReplica method enables you to create a replica based on the current replicable database.
 * The NewPassword method enables you to assign a password to a database.

Recordset Object:
 * The GetRows method enables you to retrieve rows from a recordset into an array.

TableDef Object:
 * There are three new Tabledef properties for database replication: Replication, Replicable, KeepLocal, and ConflictTable.

Container Object:
 * The AllPermissions property returns all permissions for an object, including group permissions.

Document Object:
 * The AllPermissions property returns all permissions for an object, including group permissions.
 * The Summary Info document enables you to store information such as "Title," "Subject," and "Author."
 * The UserDefined document enables you to store user-defined properties.

All Objects:  If you want to remove support for obsolete objects, methods, properties, and functions, you can establish a reference to the Microsoft DAO 3.0 Object library and remove any reference to the Microsoft DAO 2.5/3.0 Compatibility Library.

For more information about when to reference the Microsoft DAO 3.0 Object library, please see the following article in the Microsoft Knowledge Base:

129857 When to Use the New 3.0 DAO TypeLib in Visual Basic



Obsolete Features
The following is a list of data access object methods, properties, objects, and functions that have been replaced in the Microsoft Jet database engine version 3.0. Obsolete feature                     Replacement feature -

All CreateDynaset methods            OpenRecordset method

All CreateSnapshot methods           OpenRecordset method

All ListFields methods               Fields collection

All ListIndexes methods              Indexes collection

CompactDatabase statement            DBEngine.CompactDatabase method

CreateDatabase statement             DBEngine.CreateDatabase method

DBEngine.FreeLocks method            DBEngine.Idle method

DBEngine.SetDefaultWorkspace method  DBEngine.DefaultUser and DBEngine.Password properties

DBEngine.SetDataAccessOption method  DBEngine.IniPath property

Database.BeginTrans method           Workspace.BeginTrans method

Database.CommitTrans method          Workspace.CommitTrans method

Database.Rollback method             Workspace.Rollback method

Database.DeleteQuerydef method       Delete method

Database.ExecuteSQL method           Execute method

Database.ListTables method           Tabledefs collection

Database.OpenQuerydef method         Querydefs collection

Database.OpenTable method            OpenRecordset method

Index.Fields property                Index.Fields collection

OpenDatabase statement               DBEngine.OpenDatabase method

Querydef.ListParameters method       Parameters collection

Snapshot object                      Recordset object

Dynaset object                       Recordset object

Table object                         Recordset object NOTE: These obsolete methods, properties, objects, and functions are still available in applications that use the Microsoft Jet database engine version 3.0, as long as you have a reference to the Microsoft DAO 2.5/3.0 Compatibility Library.

