Public Sub ConnectUserDb()
On Error Resume Next
Set cn = New ADODB.Connection
cn.ConnectionString = "DBQ=" & App.Path & "\UserDb.mdb;DefaultDir=" & App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & "DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & "MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & "Threads=3;UID=;UserCommitSync=Yes;PWD=;"
cn.CursorLocation = adUseClient
cn.Open
End Sub用插入语句总不能正确插入
cn.Execute "insert into User(UserId,Password,Level) values(Trim(UserId),Trim(UserPsw),Trim(UserLevel))"
On Error Resume Next
Set cn = New ADODB.Connection
cn.ConnectionString = "DBQ=" & App.Path & "\UserDb.mdb;DefaultDir=" & App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & "DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & "MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & "Threads=3;UID=;UserCommitSync=Yes;PWD=;"
cn.CursorLocation = adUseClient
cn.Open
End Sub用插入语句总不能正确插入
cn.Execute "insert into User(UserId,Password,Level) values(Trim(UserId),Trim(UserPsw),Trim(UserLevel))"
2、字段类型与变量类型匹配
http://xmhabo.com/bbs/dispbbs.asp?boardID=11&ID=181&page=1
请发表感想哦!
更多图片请访问:http://inet.1m.cn BBS
cn.ConnectionString = "Provider='Microsoft.Jet.OLEDB.4.0';Data Source= 'UserDb.mdb;"
cn.CursorLocation = adUseClient
cn.Opencn.Execute "insert into User(UserId,Password,Level) values(" & Trim(UserId) & ",'" & Trim(UserPsw) & "'," & Trim(UserLevel) & ")"