General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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? Right now, I'm just using a Data Control. I tried Code earlier, when I started having the problem.
>>
>
>What is a data control?
>
>Have you made sure that you have read/change rights as far as the network goes? There is no secret switch or anything...
>
>can you make changes to the table in the command window?
Let me first say that I am attempting this in VB, not VFP. There is a not a "Command Window" in VB that I know of. I can update the table in VFP, not problem. The data control I spoke of is a Common Control that comes with VB.
I can now Update the Table using the Data Control, but no not DAO code. I am not on a network. Table is local. My Table Open codes 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.
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