用VB修改ACCESS数据
我创建了一个ACCESS,里面有个表abc,字段ddd
ddd中有信息:mmm
我要用VB让这信息mmm修改成aaa(按钮)
[解决办法]
private sub command1_click()
dim conn as new adodb.connection
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;" & _
"Persist Security Info=False"
conn.execute " update abc set ddd='aaa' where ddd='mmm'"
end sub
[解决办法]
楼上正解