I developped a VB program that use Access as its DB backend. All my query are successful but one which is:
SELECT * FROM tblClients WHERE (tblClients.Nom) Like 'camio*' ORDER BY Nom
the above is generated from my VB program (I pasted it from the VB Espions. It returns 0 rows but when I paste this query directly into Access, it returns 50 rows which are what I would like to happen in my VB program :)
If anyone has a tips or a pointer to the right direction to use.. I'd appreciate it.