General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Problems Updating VFP Table with VB
Bare with me, guys. I am new to Universal Thread. I think I posted this to the VFP FOrum. Should be in VB. I hope I got it right this time.
I have opened a VFP 5.0 Table with VB 5.0. It opens up & I can see all that data. However, if I try an update type command, i.e. Update, AddNew, Edit, etc. I get Runtime Error 3027 "Can't Update. Database or object is read-only".
I know that this Directory & all Tables in it are NOT readonly. I have tried other .DBFs & get the same result. Is there some secret to this? This is a local table, not on a Network drive.
I can Update the Table using the Data Control, but not DAO code. I am not on a network. Table is local. My Table Open code is:
Dim dbAPSS As Database
Dim rsCust As Recordset
Set dbAPSS = DBEngine.Workspaces(0).OpenDatabase(App.Path, False, False, _
"FoxPro 3.0")
Set rsCust = dbAPSS.OpenRecordset("Cust2", dbOpenTable)
My probelm, still is when I use the Update method, I get an error message that Table it read only.
Any thoughts?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only