>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
>
>
>Now, 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 lnConnectionHandle
>
>
>It 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! :)
what if you move/copy your mdb files elsewhere? Still have the same problem?
Peter
Peter Cortiel