Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC to Access
Message
De
22/12/2003 13:09:27
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
ODBC to Access
Divers
Thread ID:
00861351
Message ID:
00861351
Vues:
55
Hello,

I am trying to open an Access mdb in VFP using ODBC.

The mdb is password-protected and uses some OCX for security.

Here is the shortcut that successfully opens the mdb from the desktop. Without the OCX portion, access is denied.

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\somepath\somedata.mdb" /wrkgrp "C:\somepath
\SSwsp32.ocx" /user "username" /pwd "password"

QUESTION:
How can I include this OCX parameter in the ODBC definition so that VFP can open Acces tables as remote views ?

Note: An alternative to the command line is to change a registry setting to use the OCX. Is there a way to do it at the ODBC level ?

Thanks

Henry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform