I'm using VB5 Enterprise and I want to open and manipulate (update, append, etc) a FoxPro 5.0 database. I use the Data control and I set some properties of it in almost the same way that for an Acces Database but I get an error message in Opendatabase method.
I config my Data control properties as follows:
Data1.Connect = "Foxpro 3.0;"
Data1.DatabaseName = "Path of Fox Database.."
Data1.DefaultType = 2 'UseJet
Data1.RecordSource = "table of Fox database"
I get an error message saying the doesn't recognize the database format. But, if I use the next statament...
Data1.Connect = "FoxPro 3.0; My database path and filename ..."
The Fox Database opens well and I can bind the fields of the database to some controls but I can't open a recordset because I receive an error.
What's heppening?
Any idea will be very appreciated!
Thank!
Ulises
