Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00616353
Message ID:
00616355
Views:
29
>Is it possible to open a stand-alone VFP or Fox2x table using
>ADO? Or does the table need to be in a database?
>
>Thanks

You can access free tables. Here's the code I just tested on FPW 2.6 tables
oCon = CREATEOBJECT("adodb.Connection")
oCon.ConnectionString = [Provider=VFPOLEDB.1;Data Source=H:\FPW26\Userdata;] + ;
      [Mode=ReadWrite|Share Deny None;Password="";Collating Sequence=MACHINE]
oCon.Open
oRs = CREATEOBJECT("adodb.recordset")
oRs.ActiveConnection = oCon
oRs.Open("Select * FROM customer")
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform