请看代码:
dim wrksp As Workspace
dim dbs As Database
dim rec As dao.Recordset Set wrksp = CreateWorkspace("odbcworkspace", "admin", "", 1)
Set dbs = wrksp.OpenDatabase("hero", dbDriverNoPrompt,False, "ODBC;DSN=hero;_
UID=sa;PWD=10241;DATABASE=hero") '数据库连接没问题ODBC
Set rec = dbs.OpenRecordset("select * from department", dbOpenSnapshot) rec.AddNew '运行到这一句报错,说: can't update ,Databse or object is read-only
With rec
!depnaem = Text1
!descript = Text2
!charg = Text3
.Update
End Withcan't update ,Databse or object is read-only倒底是为什么啊!
我查看了rec.updatable 确实为flase
但是又不能直接修改这个属性(这个属性是只读的!)请问我可以怎么修改recordset对象的updatable属性啊!
dim wrksp As Workspace
dim dbs As Database
dim rec As dao.Recordset Set wrksp = CreateWorkspace("odbcworkspace", "admin", "", 1)
Set dbs = wrksp.OpenDatabase("hero", dbDriverNoPrompt,False, "ODBC;DSN=hero;_
UID=sa;PWD=10241;DATABASE=hero") '数据库连接没问题ODBC
Set rec = dbs.OpenRecordset("select * from department", dbOpenSnapshot) rec.AddNew '运行到这一句报错,说: can't update ,Databse or object is read-only
With rec
!depnaem = Text1
!descript = Text2
!charg = Text3
.Update
End Withcan't update ,Databse or object is read-only倒底是为什么啊!
我查看了rec.updatable 确实为flase
但是又不能直接修改这个属性(这个属性是只读的!)请问我可以怎么修改recordset对象的updatable属性啊!
解决方案 »
- 关于VB数据类型转换的一个小小问题,懂的高手来解答
- DataGrid控件怎么显示连接的sql数据库?
- 如何让界面更漂亮
- 关于vb 中数据输入在数据库的显示问题
- 如何让子窗体显示在父窗体的中间?
- 请问如何关闭MDI窗体中的所有子窗体?
- 如何用 Winsock 发送和接收二维数组?
- 用VB如何于Access数据库建立连接,急 100分相送
- 还是关于那个TextBox的问题。如何存入注册表里??我是新手,能否告诉我详细点
- 版主,高手,大哥。。。。救命:如何断开网络连接?
- WebBrowser1.Navigate App.Path & "\Html\default.htm" 语句加入网页怎么不好用显示不出来网页!!!!!!!!!!
- 性欲终于降低了,高兴,散点分,请继续
不能更新,数据库或工程是只读。我一般用ADO。不用DAO
Set rec = dbs.OpenRecordset("select * from department", 1)
dbs.execute( "insert department values" & text1 ...)这样就没什么问题!