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:
01205986
Views:
18
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform