The information in this article applies to:
SUMMARYModerate: Requires basic macro, coding, and interoperability skills.
MORE INFORMATIONSuppose that your Microsoft Access database contains two references: one reference to a library database called MyDatabase, which contains a class called RecordSet, and another reference to Microsoft DAO 3.5 Object Library (or Microsoft DAO 3.0 Object Library in version 7.0), which also contains a class called RecordSet. In order to dimension a variable of type RecordSet from the MyDatabase reference, you must use the following syntax:
If you do not explicitly declare the reference name when you dimension the
variable, then whichever reference appears first in the References dialog
box is automatically assumed. If the wrong reference is assumed, you may
encounter error messages when you try to use the properties and methods of
the declared object.
You can use the Microsoft Access Object Browser to determine the reference name. To use the Object Browser, open any module in Design view, and then click Object Browser on the View menu (or press the F2 key). The name that appears in the Project/Library box (or in the Libraries/Databases box in version 7.0) of the Object Browser is the name of that reference. In Microsoft Access 7.0, if there is a dash (-) in the name of a reference, use the characters to the left of the dash as the reference name. For example, if you see "DAO - Microsoft DAO 3.0 Object Library" in the Libraries/Databases box, use DAO as the name of the reference. REFERENCES
For more information about setting references in a Microsoft Access
database, search the Help Index for "setting references."
Additional query words:
Keywords : kbcode AccCon |
Last Reviewed: September 28, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |