I have an application that was referring to dao 3.51 for accessing an Access 97 database. Since the organization is in the process of upgrading to Office 2000 I need to change the reference to dao 3.6. However, when I do so, the code line
set rsExport = dbExport.OpenRecordset("select * from export where out = '' or out = null", dbOpenDynaset)
no longer returns any records. Resetting the reference to dao 3.51 brings up 140 records, all with null in the field "out".
What am I missing here?