I am trying to implement a search feature for a contact program. The VB\ADO code statement is:
Dim rs as NEW ADODB.Recordset
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Source = "SELECT * FROM Contacts WHERE FullName LIKE '*a*';"
.ActiveConnection = dbConnection 'ado connection object
It returns 0 records whe executing from vb (77 when running from Access). Is there some limitation when using the like statement from VB\ADO?