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:
01205957
Views:
20
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=')
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform