in reply to MS Access empty results

Honestly, my first thought would be to suspect a bug in the database implementation, or in the ODBC interface for that particular database.

The workaround that I'd try would be to enumerate all the needed fields in the select, i.e.:

select field1,field2,...fieldlast from table
Perhaps by explicitly naming all the fields you can get what you need?