lnConnHandle = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq="'+ lcMDBDir+'\'+lcMDBName+'";Uid=Admin;Pwd=;')Here's what I typed in and I think they are the same, but it returned a -1 value. It did get further through the program but I should have tested for a -1 return value and stopped the program at that point. I'll do that.
lnConnHandle = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq="'+ lcMDBDir+'\'+lcMDBName+'";Uid=Admin;Pwd=;')