XL97: Revised Dao350.dll File for "No current row" Error

Last reviewed: March 18, 1998
Article ID: Q182596

The information in this article applies to:

Microsoft Excel 97 for Windows

SUMMARY

A revised Dao350.dll file that fixes a problem that may occur when you run a Visual Basic for Applications macro that uses Data Access Objects (DAO) is available. When this problem occurs, the following error message appears:

   Run-time error '40009':
   No current row.

For additional information about this problem, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q172322
   TITLE     : XL97: Run-Time Error 40009 when you Run DAO Macro

The following file is available for download from the Microsoft Software Library:

 ~ Newdao.exe (size: 255200 bytes)

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

The FTP location is the following:

   ftp://ftp.microsoft.com/Softlib/MSLFILES/

MORE INFORMATION

This Dao350.dll file is the same file that is included with Microsoft Excel 97. The version and date of the file have been changed to prevent Microsoft Visual Basic version 5.0 from replacing Dao350.dll with a newer version that is not fully compatible with Microsoft Excel 97.

After you install this revised file, you can install Microsoft Visual Basic or custom Visual Basic applications without having to manually replace the Dao350.dll file that is included with Microsoft Excel 97 after each installation. To see the contents of the Readme file that is included with the revised Dao350.dll file, see the "Contents of the Readme File" section.

NOTE: This revised file does not resolve the problem if the recordset contains a field of type BIGINT.

Contents of the Readme File

The revised Dao350.dll file that is included in the Newdao.exe file corrects a problem that prevents you from running Visual Basic(R) for Applications macros that use Data Access Objects (DAO). Without this revised Da0350.dll, the macro may fail and you may receive the following error message:

   Run-time error '40009':
   No current row.

NOTE: This is the same Dao350.dll that is included with Microsoft Excel 97 for Windows(R). The version and date of Dao350.dll have been changed to prevent Microsoft Visual Basic version 5.0 (or a Visual Basic application that uses DAO) from replacing it with a version of the file that has a later date but that is not fully compatible with Microsoft Excel 97.

To correct the problem, follow these steps:

Close all programs.
On the Start menu, point to Find, and click Files Or Folders.
In the Named box, type "Dao350.dll" (without the quotation marks). In the Look In box, select "(C:)" (or the hard disk drive in which Microsoft Windows is located). Click to select the Include Subfolders check box, and then click Find Now.
One copy of the original Dao350.dll should be in the following folder
```
      <WinDrv>\Program Files\Common Files\Microsoft Shared\Dao
```
where <WinDrv> is the disk drive letter for the hard disk on which Windows is installed.
Right-click each Dao350.dll file. On the shortcut menu, click Rename. Change the name of the file to "Dao350.vb5" (without the quotation marks). Press ENTER.
These files are backup copies of the existing Dao350.dll files.
Start Microsoft(R) Windows Explorer and open the following folder
```
      <WinDrv>\Program Files\Common Files\Microsoft Shared\Dao
```
where <WinDrv> is the disk drive letter for the hard disk on which Windows is installed.
Copy the downloaded Dao350.dll into the folder you opened in step 5.

You can now safely install Microsoft Visual Basic version 5.0 (or Microsoft Visual Basic applications that use DAO) without affecting DAO in Visual Basic for Applications.

REFERENCES

For more information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q163435
   TITLE     : VBA: Programming Resources for Visual Basic for
               Applications

Additional query words: Run-time error 40009 vba
Keywords : xlvbainfo xlwin xldao kbprg OffVBA
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.