好像是错了!
后面你Execute的sql语句的对象应该是adodb.recordset吧!可以dim DbRd as New adodb.recordset
set dbrd=.....
试试吧!我好久没碰过VB了 。有点印象!!
后面你Execute的sql语句的对象应该是adodb.recordset吧!可以dim DbRd as New adodb.recordset
set dbrd=.....
试试吧!我好久没碰过VB了 。有点印象!!
是文本的么?
Dim dbtest As New ADODB.Connection
If dbtest.State = adStateOpen Then dbtest.Close
dbtest.CursorLocation = adUseClient
dbtest.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\lxy_winner\桌面\hello\webofficeSQL.mdb;Persist Security Info=False"
sql1 = "update users set 用户标识 = 'ww'"
dbtest.Execute sql1End Sub看我的和你的没有区别
你的password属性错了
数据库:password
表:pwd
表中的列:id(自动编号)和password(文本)
[email protected]