Access 2016 DAO.Recordset returns table name instead of column value (1 Viewer)

[SkyCraw]

Original post here.

Just wondering if anyone here has had any recent DAO VBA issues in Access 2016/2019 where the same code works just fine in 2007. This issue seems to have sprouted around June 10th, but I can't seem to find any Windows 10/Office 2016/2019 Click-To-Run updates correlating specifically with DAO references.

 

[theDBguy]

Hi. There was a recent issue with Decimal data types. I wonder if this is related to that.

 

[SkyCraw]

Looks like it was something to do with one of recent Version 2005 updates for Office that bricked my code. Reverting back to Version 2004 (Build 12730.20270) fixed this issue for me.

EDIT: Will need to watch for Office updates now...

 

[theDBguy]

Looks like it was something to do with one of recent Version 2005 updates for Office that bricked my code. Reverting back to Version 2004 (Build 12730.20270) fixed this issue for me.

EDIT: Will need to watch for Office updates now...

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

 

[Pat Hartman]

Would you care to share the code that "broke"? And the error message or invalid result.