It's obvious that you mistyped Access DB name/path in your previous attempts.
>Maybe I had a spelling error. I am not sure. So, thinking that maybe I was goofing up the spelling, I looked up the actual path in Windows Explorer and copied it into the double quotes for the variable lcMDBPath. It gave me a connection handle of 1, which is a miracle. Sorry to have troubled so many people on this. It may have been something really ridiculous, but I don't really know for sure.
>
>I have no problem connecting to Access DB in the 'Program Files' subdirectory. Where do you get an error?
>Your code:
>
>lcMDBPath = "C:\Program Files\Microsoft Office\Office12\1033\dbsample.mdb"
>lnConn = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=')
>
--sb--