I report a bug using ODBC connector through VBA. Assuming I have a table named 'companies' with 3 rows in there.
When doing this query:
Then it returns the correct results:
But when doing a query with more than one field, then
The query returns this:
This means that any query with more than one field selected returns the first row twice, and doesn't show the last row. Even with more than 20+ rows in my table the result is the same...
Any idea of the origin of this bug?
Thanks a lot
– EDIT –
Here is the connection string used in VBA:
I've figured out that the use of 'rsDB.CursorLocation=aduseServer' is the cause of the issue. When commenting these 2 lines, my requests seems to work well.