连接有密码的数据库
Dim cnn1 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cnnstr As String
Set cnn1 = New ADODB.Connection
cnn1.Open "provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Jet OLEDB:Database Password=1111"Set rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from 11", cnn1Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
Dim cnn1 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cnnstr As String
Set cnn1 = New ADODB.Connection
cnn1.Open "provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Jet OLEDB:Database Password=1111"Set rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from 11", cnn1Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
解决方案 »
- 怎么获得选择的文件名并打开?
- 如何最高效地处理Excel表格中的数据??
- combobox的使用
- 我相信可以实现的!
- 怎样判断数据库中日期字段的值是不是在当月内??
- 这段代码错在哪里??tb.Open "select from inuser where 部门='" & Combo1.Text & "'", tbs
- ACCESS{}
- vb程序在WINXP和WIN2K中执行差异
- 一个关于控件之间数据传递的问题,请各位大侠帮忙
- 用键盘控制窗体上的commandbutton运动时,如何消除commandbutton的停滞感??(内详)
- vb中有没有好的时间控件?推荐仪下,谢谢
- 怎么样改变窗体的启动顺序?
Dim strPwd As String
strPwd = GetSetting(App.EXEName, "Login", "PassWord", "") '从注册表中取出
strPwd = DeCipher(strPwd)
'然后用strPwd去打开数据库
'...
End Sub
Private Sub cmdChangePassword_Click()
SaveSetting App.EXEName, "Login", "PassWord", Cipher(txtPassWord.Text) '保存到注册表
End Sub
Private Function Cipher(strText) As String
'加密,返回加密后的字符串
'...
End Function
Private Function DeCipher(strText) As String
'解密,返回原字符串
'...
End Function