lcMDBPath = "C:\Program Files\Microsoft Office\Office12\1033\dbsample.mdb" lnConn = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=')>Peter, even this one bombed; VFP doesn't like, or maybe it's ODBC, doesn't like the space I think in "\Program Files". Even with the below one I still get the same error, invalid path and invalid file name.
>STORE SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=') TO lnConnectionHandle >>
>lcMDBPath = "C:\Program Files\Star\the.mdb" >STORE SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=') TO lnConnectionHandle >>