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=')