Hi,

I'm on VB6 and using the DAO(JET-engine) you have to replace any pipe symbol ("|") in a query with " & CHR(24) & ".
But now I'm on ADO and am using the Provider=Microsoft.JET.OLEDB... or Driver={Microsoft Access Driver... and it seems it's not necessary anymore, but I'm not certain.
When using ADO is it still necessary to replace the pipe symbol or can I leave it like it is? (which means I can remove a Replace in my StrQueryString function).