DAO editing Foxpro file

[bservello]

I'm having a difficult time opening a Foxpro File in DAO which allows updates

Set db = OpenDatabase("C:\BRUNO", False, False, "FoxPro 2.6;")

Set rs = db.OpenRecordset("TEST", dbOpenTable)

This allows me to open the file but not update.

What's wrong.


B. Servello

[Ober]

I don't know much about FoxPro but I know in Access
I have to use something like this.

With RS
.Edit
!The_Field = "What I want to add"
.Update
End With

Try it and if works let me know.
Becuase then I can start to use FoxPro instead of Access withouth any serious changes to my way of coding.

[Ober]

If you open it be sure to close it!


RS.Close
DB.Close

I don't know if that will work in FoxPro either.