Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP tables from Access
Message
From
26/02/2004 14:05:34
 
 
To
26/02/2004 10:43:35
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00881064
Message ID:
00881198
Views:
18
sorry, i wasn't clear enough. yes, i know. this code works just fine in access

Dim cConnectString, oRS As ADODB.Recordset, oConn, cString As String
cConnectString = "Provider=VFPOLEDB.1;Data Source=c:\Archivos de programa\Microsoft Visual FoxPro 8\Samples\Data\testdata.dbc;" & _
"Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE"
Set oConn = CreateObject("ADODB.Connection")
oConn.ConnectionString = cConnectString
oConn.ConnectionTimeout = 30
oConn.Open
cSQL = "select * from customer"
Set oRS = oConn.Execute(cSQL)

now, the question is how do i link that table (customer) in a ms access database using the vfpoledb provider. is that even possible ?
Previous
Reply
Map
View

Click here to load this message in the networking platform