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