The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). SYMPTOMS
By default, a new Microsoft Access 2000 database does not reference the Microsoft DAO 3.6 Object Library. This is a change from earlier versions of Access.
-or-
RESOLUTIONDevelopers who want to use the Data Access Object (DAO) library instead of, or in addition to, the new Microsoft ActiveX Data Object (ADO) model, must manually set the reference in each new database. MORE INFORMATIONMicrosoft DAO 3.6 and ADO 2.1 have several object names in common, such as Database and Recordset. If you reference both DAO 3.6 and ADO 2.1, and you do not specify which library you are using to declare an object, your code may cause an error or not run as expected. To specifically declare an object in a library, use the prefix for the library. For example, the following lines declare a variable as a database: Using DAO 3.6By always using a prefix to define which library your objects are being declared in, you can eliminate possible errors caused by objects being declared from the wrong library. Using the prefix also makes your code easier to read.Using ADO 2.1 Converted databases automatically update the Microsoft DAO 3.x reference to Microsoft DAO 3.6. To manually include the reference to the DAO 3.6 Object library, follow these steps:
REFERENCESFor more information about the new Microsoft ActiveX Data Object (ADO) model, in the Visual Basic Editor, click
Microsoft Visual Basic Help on the Help menu, type
using ActiveX Data Objects in the Office Assistant or the Answer Wizard, and
then click Search to view the topic. Additional query words: prb
Keywords : kbdta CnvVerDif MdlVb MdlDao MdlLib |
Last Reviewed: August 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |