I have 1 Data control, and want to use 1 DBGrid, with 2 columns. Column 1 is from a fpw26 dbf (read only), and column 2 is a text file (read/write). Both have the same number of rows/lines. I'm using win 95, fpw26, and VB5 pro

I know how to use one Data, DBGrid, and foxpro 2.6 dbf file using the Properties Window, but I'm having trouble setting it up using only code. Either I get "file does not exists" or "class doesn't support Automation"

This is what I have so far, which isn't much.

Dim FoxFreeDB As Database
Dim FoxFreeRS As Recordset
Set FoxFreeDB = OpenDatabase("D:\cdset\testit", False, False, "FoxPro 2.6;") ' change to True,True once it works
Set FoxFreeRS = FoxFreeDB.OpenRecordset("cdprog.dbf")

any other code I add like "Data1.RecordSource =" or "DBGrid1.DataSource =" gives errors. I made sure all dlls and DBengines where up to date and registered. but I can't get the grid to display the field I want, and my Select statement gives a "Complie error : Expected: Case"

If I have to, I'll just use one dbf file, but can I make one column read only, and the other read/write ?