I am very new to Databases and keep getting this error in VB6 : "Syntax Error in FROM Clause"
I'm using a MS Access database connected to my project via the Adodc control which has it's recordsource properties set to my table (Clients), I am trying to filter my clients table to only show client records that match the SQL query for the field (username)
Dim strSql As String
strSql = "SELECT * FROM clients WHERE username LIKE '*abc*'"
Adodc1.RecordSource = strSql
All help will be highly appreciated, many thanks, Devan