Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing foxpro table
Message
From
17/08/2000 10:17:00
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Accessing foxpro table
Miscellaneous
Thread ID:
00406065
Message ID:
00406065
Views:
59
Can anyone show me how to access a foxpro table using ADO?
I have the following code:

Dim sWorkspace As Workspace
Dim sDatabase As Database
Dim sTable As Recordset

Set sWorkspace = DBEngine.Workspaces(0)
Set sTable = sWorkspace.OpenDatabase("c:\cmts2\cycle14\arpbal2.dbf")
Set sAction = sTable.OpenRecordset("Select * from arpbal2")

But I get an error message at the second Set statement that goes:

Run-time error '3343':

Unrecognized database format 'c:\cmts2\cycle14\arpbal2.dbf'.

Would appreciate any help. Thanks.

Ramon
Next
Reply
Map
View

Click here to load this message in the networking platform