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

ID: Q182596

The information in this article applies to:

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:
Q172322 XL97: Run-Time Error 40009 when you Run DAO Macro
The following file is available for download from the Microsoft Software Library:
Newdao.exe
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:
Q119591 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.

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:

Q163435 VBA: Programming Resources for Visual Basic for Applications

Additional query words: Run-time error 40009 vba 


Keywords          : kbprg kbdta OffVBA xldao KbVBA xlwin 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: June 21, 1999