Thanks all for your prompt replies.

Good point Paul, I guess I didn't make it obvious in the open method, I passed the SQL string. I have since changed the variable.

Bigley, it wasn't returning any data.

Ian, I got the same advice as you provided from an online user last night and was able to fix my problem. I was under the (mis)understanding that the % wildcard was to be used only if you are connecting to an SQL Server database.

Thanks again.
Mary Lou