-
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
-
Maybe..
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.
-
Don't Forget
If you open it be sure to close it!
RS.Close
DB.Close
I don't know if that will work in FoxPro either.