VB用ADO写ACCESS数据库,在别的机器上写不进去。
时间:2011-09-28
来源:互联网
代码如下
Private Sub Writedata(Readdata)
Dim SQL As String
Dim Readed
Dim Ti1, Da1
Dim Cal1, Bale1, Gr1, Net1, Forte1, Mr1, IntWt1
Readed = Readdata
'Ti1 = Format(Readed(1), "hh:mm")
'Da1 = Format(Readed(2), "yy-mm-dd")
Ti1 = CStr(Readed(1))
Da1 = CStr(Readed(2))
Cal1 = CStr(Readed(3))
Bale1 = CStr(Readed(4))
Gr1 = CStr(Readed(5))
Net1 = CStr(Readed(6))
Forte1 = CStr(Readed(7))
Mr1 = CStr(Readed(8))
IntWt1 = CStr(Readed(9))
StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Data_P & ";Persist Security Info=False"
Conn.open StrConn
SQL = "Insert Into Nowbale (Times,Dates,Calibration,BaleNUM,GrWt,NetWt,ForteNUM,Mr,IntWt) Values( '" & Ti1 & "','" & Da1 & "','" & Cal1 & "','" & Bale1 & "','" & Gr1 & "','" & Net1 & "','" & Forte1 & "','" & Mr1 & "','" & IntWt1 & "')"
Set RS = Conn.Execute(SQL)
Conn.Close
End Sub
在编译好后都能运行,就是安装到没有安装中文字库的XP英文机上使用时总是不将数据写到数据库中,也没报错程序仍然在执行,到别的机器上(英文中文)安装运行没有任何问题。
Private Sub Writedata(Readdata)
Dim SQL As String
Dim Readed
Dim Ti1, Da1
Dim Cal1, Bale1, Gr1, Net1, Forte1, Mr1, IntWt1
Readed = Readdata
'Ti1 = Format(Readed(1), "hh:mm")
'Da1 = Format(Readed(2), "yy-mm-dd")
Ti1 = CStr(Readed(1))
Da1 = CStr(Readed(2))
Cal1 = CStr(Readed(3))
Bale1 = CStr(Readed(4))
Gr1 = CStr(Readed(5))
Net1 = CStr(Readed(6))
Forte1 = CStr(Readed(7))
Mr1 = CStr(Readed(8))
IntWt1 = CStr(Readed(9))
StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Data_P & ";Persist Security Info=False"
Conn.open StrConn
SQL = "Insert Into Nowbale (Times,Dates,Calibration,BaleNUM,GrWt,NetWt,ForteNUM,Mr,IntWt) Values( '" & Ti1 & "','" & Da1 & "','" & Cal1 & "','" & Bale1 & "','" & Gr1 & "','" & Net1 & "','" & Forte1 & "','" & Mr1 & "','" & IntWt1 & "')"
Set RS = Conn.Execute(SQL)
Conn.Close
End Sub
在编译好后都能运行,就是安装到没有安装中文字库的XP英文机上使用时总是不将数据写到数据库中,也没报错程序仍然在执行,到别的机器上(英文中文)安装运行没有任何问题。
作者: easycxj 发布时间: 2011-09-28
那就做个安装包安装后再运行
作者: Leftie 发布时间: 2011-09-28
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28