Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting data in MSACCESS
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01192149
Message ID:
01205943
Views:
23
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! :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform