>>>How about double quotes around the path? The original problem was related to a space in the path.
>>
>>In that case
>>
lcFullPath=forcepath(lcMDBName, lcMDBDir)
>>cString=textmerge([Driver={Microsoft Access Driver (*.mdb)};Dbq="<<lcFullPath>>";Uid=Admin;Pwd=;]
>>lnConnHandle=sqlstringconnect(cString)
>>if lnConnHandle<1
>> aerror(ee)
>> messagebox(ee[2])
>>endif
>
>He-he <g> And what if you don't have a space? You just wasted a double quote <g>
A double quote is never alone - they come in pairs. Should be called quad quotes :).
No waste though, I make them from recycled bytes only.