Microsoft KB Archive/927678: Difference between revisions
(importing KB archive) |
m (Text replacement - "<" to "<") |
||
Line 65: | Line 65: | ||
# Start Access 2007. | # Start Access 2007. | ||
# Click the '''Microsoft Office Button''', and then click '''Open'''. | # Click the '''Microsoft Office Button''', and then click '''Open'''. | ||
# In the '''Open''' dialog box, locate and select <code> | # In the '''Open''' dialog box, locate and select <code><DatabaseName></code>, and then click '''Open'''. | ||
# On the '''Database Tools''' menu, click '''Visual Basic''' in the Macro group to open Visual Basic Editor (VBE).<br /> | # On the '''Database Tools''' menu, click '''Visual Basic''' in the Macro group to open Visual Basic Editor (VBE).<br /> | ||
<br /> | <br /> | ||
'''Note''' You may also press ALT+F11 to open VBE. | '''Note''' You may also press ALT+F11 to open VBE. | ||
# On the '''Tools''' menu, click '''References'''. | # On the '''Tools''' menu, click '''References'''. | ||
# In the '''References - <code> | # In the '''References - <code><DatabaseName></code>''' dialog box, click '''Microsoft Office 2007 Access database engine Object Library'''. | ||
# Click the '''Priority''' arrow to move '''Microsoft Office 2007 Access database engine Object Library''' above '''Microsoft ActiveX Data Objects''', and then click '''OK'''. | # Click the '''Priority''' arrow to move '''Microsoft Office 2007 Access database engine Object Library''' above '''Microsoft ActiveX Data Objects''', and then click '''OK'''. | ||
Line 84: | Line 84: | ||
<li>Start Access 2007.</li> | <li>Start Access 2007.</li> | ||
<li>Click the '''Microsoft Office Button''', and then click '''Open'''.</li> | <li>Click the '''Microsoft Office Button''', and then click '''Open'''.</li> | ||
<li>In the '''Open''' dialog box, locate and select <code> | <li>In the '''Open''' dialog box, locate and select <code><DatabaseName></code>, and then click '''Open'''.</li> | ||
<li>On the '''Database Tools''' menu, click '''Visual Basic''' in the Macro group to open VBE. | <li>On the '''Database Tools''' menu, click '''Visual Basic''' in the Macro group to open VBE. | ||
<div class="indent"> | <div class="indent"> | ||
Line 92: | Line 92: | ||
</div></li> | </div></li> | ||
<li>On the '''Tools''' menu, click '''References'''.</li> | <li>On the '''Tools''' menu, click '''References'''.</li> | ||
<li>In the '''References - <code> | <li>In the '''References - <code><DatabaseName></code>''' dialog box, click to clear '''Microsoft ActiveX Data Objects''', and then click '''OK'''.</li></ol> | ||
Revision as of 09:32, 21 July 2020
Article ID: 927678
Article Last Modified on 10/15/2007
APPLIES TO
- Microsoft Office Access 2007
SYMPTOMS
When you convert a database file from an earlier version of Microsoft Access into a Microsoft Office Access 2007 file, the application may stop responding if you try to run or compile code that uses Data Access Objects (DAO). Additionally, you may receive the following error message:
CAUSE
This problem occurs because the order of database references is not preserved when the database file is converted.
WORKAROUND
To work around this problem, use one of the following methods:
Method 1
In the References dialog box, make sure that Microsoft Office 2007 Access database engine Object Library is higher in priority than Microsoft ActiveX Data Objects. To do this, follow these steps:
- Start Access 2007.
- Click the Microsoft Office Button, and then click Open.
- In the Open dialog box, locate and select
<DatabaseName>
, and then click Open. - On the Database Tools menu, click Visual Basic in the Macro group to open Visual Basic Editor (VBE).
Note You may also press ALT+F11 to open VBE.
- On the Tools menu, click References.
- In the References -
<DatabaseName>
dialog box, click Microsoft Office 2007 Access database engine Object Library. - Click the Priority arrow to move Microsoft Office 2007 Access database engine Object Library above Microsoft ActiveX Data Objects, and then click OK.
Method 2
If you must reference and use both DAO and ActiveX Data Objects (ADO) object libraries, dimension the objects explicitly as follows:
Dim adoRS As ADODB.Recordset Dim daoRS As DAO.Recordset
Method 3
If you are not using an ADO object library, clear the reference to the library. To do this, follow these steps:
- Start Access 2007.
- Click the Microsoft Office Button, and then click Open.
- In the Open dialog box, locate and select
<DatabaseName>
, and then click Open. - On the Database Tools menu, click Visual Basic in the Macro group to open VBE.
Note You may also press ALT+F11 to open VBE.
- On the Tools menu, click References.
- In the References -
<DatabaseName>
dialog box, click to clear Microsoft ActiveX Data Objects, and then click OK.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Additional query words: AC2007 ACC2007
Keywords: kberrmsg kbtshoot kbprb kbexpertiseinter KB927678