STORE SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=') TO lnConnectionHandleNow, here's a scenario:
lcMDBPath = "C:\Program Files\Star\the.mdb" STORE SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=') TO lnConnectionHandleIt just bombs each and every time. I do not understand why. I've been programming in VFP all these years and I guess I'll have to shoot myself now. Ha! :)