Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting data in MSACCESS
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01192149
Message ID:
01205986
Vues:
17
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform