Unanswered: Query for known record returns no results
I'm having a problem with retrieving existing records for an acess 2000 database in VB using DAO 3.6. I wrote the following to debug and to my surprise the msgbox does come up on some machines and certian records, always the same records each time it runs. Any ideas?
Set eqry = masterDB.OpenRecordset("select * from email", dbOpenSnapshot)
Do While Not eqry.EOF
keyu = eqry("keyu")
keyd = Str(eqry("keyd"))
Set emailRS = masterDB.OpenRecordset("select * from email where keyu = '" & keyu & "' and keyd = #" & keyd & "#", dbOpenDynaset)
If emailRS.EOF Then MsgBox "-" & keyu & "-" & keyd & "-"