Is that correct, or is there a patch that fixes that?
I've tried on 2 systems: one with Access 2003 and another with Access 2010.
When I Google the topic I can't seem to get confirmation.
This kind of code seems to always result in rst.EOF=True if referring to a linked SQL Server table:
Expand|Select|Wrap|Line Numbers
- Public Function TestMinus1()
- Dim sql As String
- Dim rst As DAO.Recordset
- Dim db As DAO.Database
- Set db = CurrentDb
- sql = "SELECT MyBlnField FROM MyTable WHERE MyBlnField=-1"
- Set rst = db.OpenRecordset(sql, dbOpenDynaset, dbSeeChanges)
- If rst.EOF Then
- Debug.Print "Nothing returned"
- End If
- End Function