在VB里面不能用ADO对象执行操纵ACCESS的SQL语句,如UPDATE,DELETE,只能执行SELECT语句,为什么?
南飞雁 2002-01-23 11:29:48 Dim cnStr As String
Dim cn as new connection
cnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\house.mdb"
cn.CursorLocation = adUseClient
cn.Open cnStr
cn.Execute "update customer set age = 25"
cn.close
set cn = nothing
在cn.execute处出现错误!其他语句也不行,只能执行SELECT语句,为什么?