Dim cn As ADODB.Connection, n As Long
Set cn = New ADODB.Connection
cn.Open Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\1.mdb;"
cn.Execute "UPDATE chk_serial SET chk_flg = 1 WHERE product_code='" & Text1 & "' AND kibam_name ='" & Text2 & "' AND serial_id = '" & Text3 & "'", n
cn.Close
Set cn = Nothing
If n Then MsgBox "Updated"
Set cn = New ADODB.Connection
cn.Open Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\1.mdb;"
cn.Execute "UPDATE chk_serial SET chk_flg = 1 WHERE product_code='" & Text1 & "' AND kibam_name ='" & Text2 & "' AND serial_id = '" & Text3 & "'", n
cn.Close
Set cn = Nothing
If n Then MsgBox "Updated"
提示不允许操作
cn.Open Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\1.mdb;User Id=admin;Password=;" 或者换到其他路径试试。再看看此路径或文件是否设置为“只读”。最后,你把 SQL 语句(注意把 TextBox 控件的变量都变为实际的字符串值)贴到 Acess 中执行一下。