ADO and Access query wildcards (2000/XP)

Topic

New Reply

Thanks, I’m sure this will help others – the difference can be bewildering!

Reply | Quote

Replies

Edited by HansV to update URL and make it clickable – see Help 19

This isn’t a question but the solution to a problem I had earlier today.
I’ve had a quick search and didn’t find anything here but apologies if I didn’t look hard enough and this info is duplcated elsewhere in the lounge.

I was opening a recordset in code using ado but it was returning EOF = True. The query forming the source of the recordset definitely contained records.
I eventually realised this was because the WHERE criteria in the query contained the wildcard symbol * and ADO requires %.

Changing the * to % in the query returned the correct number of records in the recordset.

BUT opening the query from the databse window returned nothing

Eventually found this article Using the Right Wildcard Characters in SQL Statements

And discovered changing the word ‘Like’ to ‘ALike’ allows the use of the ADO wildcard in the Access query grid

Reply | Quote