General information
Category:
Database DAO/RDO/ODBC/ADO
Stephen,
Unless you specify the update method in DAO, it defaults to a read-only recordset, resulting in an error if you try to update.
Also, is this a legacy app that you can't migrate to ADO code?
>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?
Previous
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