What Is New and Obsolete with DAO in MS Access 95

ID: Q140128

The information in this article applies to:

Microsoft Access versions 97, 7.0

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.

MORE INFORMATION

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

REFERENCES

For more information about new features in the Microsoft Jet database engine version 3.0, please see the following article in the Microsoft Knowledge Base:

Q137039 New Features in Microsoft Jet Version 3.0

Additional query words: inf

Keywords : kbprg kbdta MdlDao
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbhowto