高分相求数据库问题? 好何用VB打开加密过的Access数据库? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给个例子: Dim g_cnnSql As Connection Dim strConnectSetting As String Dim strDBFile as String Set g_cnnSql = New ADODB.Connection If g_cnnSql.State = adStateOpen Then g_cnnSql.Close End If strDBFile = App.Path & "\" & "Test.mdb" strConnectSetting = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=" & strDBFile & "; " & _ "Persist Security Info=False;" & _ "Jet OLEDB:Database Password=Password" With g_cnnSql .ConnectionString = strConnectSetting .CommandTimeout = 30 .CursorLocation = adUseClient .Open End With 用ADOCN.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=system.MDB;" & _ "DefaultDir=" & App.Path & ";" & _ "UID=admin;PWD=youPassWord;" 用DAOSet db = OpenDatabase(App.Path & "\data\H.mdb", False, False, ";Pwd=你的数据库密码") 用命令行把多个文件压缩成一个RAR的问题 自动提交网页,返回结果遇到的问题,求助! Type自定义类型无法传入类 关于动态数组控件的事件响应 如何把非文本文件的内容读取到文本框中 Access 中能录制宏吗? 请问, ActiveX控件在WEB页面上执行, 遇到安全问题? 袁飞大哥能不能给我你的getdisksn的源码? 简单的问题!容易得分!! 学习网络编程从何下手,谢谢。(无正文) 有没有VB写的DTS程序源代码或文档资料,能不能发一份给我谢谢 API调用的问题
Dim g_cnnSql As Connection
Dim strConnectSetting As String
Dim strDBFile as String
Set g_cnnSql = New ADODB.Connection
If g_cnnSql.State = adStateOpen Then
g_cnnSql.Close
End If
strDBFile = App.Path & "\" & "Test.mdb"
strConnectSetting = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & strDBFile & "; " & _
"Persist Security Info=False;" & _
"Jet OLEDB:Database Password=Password"
With g_cnnSql
.ConnectionString = strConnectSetting
.CommandTimeout = 30
.CursorLocation = adUseClient
.Open
End With
用ADOCN.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=system.MDB;" & _
"DefaultDir=" & App.Path & ";" & _
"UID=admin;PWD=youPassWord;"
Set db = OpenDatabase(App.Path & "\data\H.mdb", False, False, ";Pwd=你的数据库密码")