Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC to Access
Message
From
22/12/2003 13:09:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ODBC to Access
Miscellaneous
Thread ID:
00861351
Message ID:
00861351
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform