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

Article ID: 182596

Article Last Modified on 10/10/2006

Microsoft Excel 97 Standard Edition

This article was previously published under Q182596

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:

172322 XL97: Run-Time Error 40009 when you Run DAO Macro

The following file is available for download from the Microsoft Download Center:

[GRAPHIC: Download] Download Newdao.exe now

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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.

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

REFERENCES

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

163435 VBA: Programming Resources for Visual Basic for Applications

Additional query words: Run-time error 40009 vba

Keywords: kbdownload kberrmsg kbfile kbgraphxlink kbinfo kbprogramming KB182596