ACC95: What Is New and Obsolete with DAO in MS Access 95

• Microsoft Access version 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.

• 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.
• The new MoveReplica method enables you to move an existing replica to a different location.

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

• The GetRows method enables you to retrieve rows from a recordset into an array.

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

• The AllPermissions property returns all permissions for an object, including group permissions.

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

• 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:

        ARTICLE-ID: Q129857
        TITLE     : 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

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:

   ARTICLE-ID: Q137039
   TITLE     : New Features in Microsoft Jet Version 3.0

Keywords          : kbprg MdlDao
Version           : 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo