lnConnHandle = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq="'+ >> lcMDBDir+'\'+lcMDBName+'";Uid=Admin;Pwd=;') >>>>
>>lnConnHandle = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq="'+ >> lcMDBDir+'\'+lcMDBName+'";Uid=Admin;Pwd=;') >>>
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]) >endifHow about double quotes around the path? The original problem was related to a space in the path.