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:
01205947
Vues:
20
This message has been marked as the solution to the initial question of the thread.
I have no problem connecting to Access DB in the 'Program Files' subdirectory. Where do you get an error?
lcMDBPath  = "C:\Program Files\Microsoft Office\Office12\1033\dbsample.mdb"
lnConn =  SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=')
>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! :)
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform