Morning. I have a issue where I'm trying to delete records that match a certain pattern.
The code I'm using is this:
Code:
cnnDBServer = New ADODB.Connection
cnnDBServer.Provider = "Microsoft.Jet.OLEDB.4.0"
cnnDBServer.Open(strDBPath & "\XYZServer.mdb")
strSql = "DELETE tblClientFileDetails.* FROM tblClientFileDetails WHERE (((tblClientFileDetails.FileName) Like 'XyzClient*'))"
cnnDBServer.Execute(strSql)
cnnDBServer.Close()
cnnDBServer = Nothing
The process doesn't delete any of the files. If I replace the strSql with:
"Delete tblClientFileDetails.* From tblClientFileDetails" It deletes all the records so i know the code works. Also If I past the original sql into MS Access, it deletes the matching records.

I'm coding this in Visual studio 2010 and connecting to an external Access database.
Does anyone see why this doesn't work?
Thanks,
Scott