穷人提问:数据类型不匹配??
Option Explicit
Dim Cnn As ADODB.Connection, Rs As ADODB.Recordset, Str As String
Private Sub Form_Load()
'初始化ADO,连接数据库
Set Cnn = New ADODB.Connection
Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\WENJIAN.mdb;Persist
Security Info=False"
Cnn.Open Str
Set Rs = New ADODB.Recordset
Rs.Open "笔记特征", Cnn, adOpenDynamic, adLockOptimistic, adCmdTable
JianCai = LoadPicture()
YangBen = LoadPicture()
End Sub
Private Sub Command1_Click()
JianCai = LoadPicture()
YangBen = LoadPicture()
Rs.AddNew
End Sub
Private Sub Command2_Click()
Rs.Fields(0) = JianCai.Picture ‘错误就出面在这2行
Rs.Fields(1) = YangBen.Piture
Rs.Update
JianCai = LoadPicture()
YangBen = LoadPicture()
End Sub
在数据库的“笔记特征”表中的2个字段是二进制型的,为何会出现“类型不匹配”的错误呢,请朋友们帮忙解决