Private Sub Form_Load()
Dim frmoexestr As String
frmoexestr = App.Path
If Right$(frmoexestr, 1) <> "\" Then
frmoexestr = frmoexestr + "\"
End If frmoexestr = frmoexestr + "DB\pms.mdb"
adouser.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & frmoexestr & ";Persist Security Info=False;Jet OLEDB:database password=passwordkey"
adouser.RecordSource = "select * from [password] where 用户号 <> " & txt_usernum & ""
adouser.Refresh
End Sub
其他窗体的连接语句相同
可以连接及打开新窗体,但是在打开前会提示密码无效,为什么
Dim frmoexestr As String
frmoexestr = App.Path
If Right$(frmoexestr, 1) <> "\" Then
frmoexestr = frmoexestr + "\"
End If frmoexestr = frmoexestr + "DB\pms.mdb"
adouser.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & frmoexestr & ";Persist Security Info=False;Jet OLEDB:database password=passwordkey"
adouser.RecordSource = "select * from [password] where 用户号 <> " & txt_usernum & ""
adouser.Refresh
End Sub
其他窗体的连接语句相同
可以连接及打开新窗体,但是在打开前会提示密码无效,为什么
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货