怎样用Data控件访问有密码的.MDB文件??? 加上一句:Data1.Connect = ";pwd=mima" 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 A:如果你希望打開一個有密碼保護的Access資料庫,你可以用以下三種語法的任一種: Dim MyConn As New ADODB.Connection MyConn.Provider = "Microsoft.Jet.OLEDB.3.51" MyConn.Properties("Data Source") = "C:\...\JetPassword.MDB" MyConn.Properties("Jet OLEDB:Database Password") = "MyPwd" MyConn.Open -或- Dim MyConn As New ADODB.Connection Dim strConn As String strConn = "Data Source=C:\...\JetPassword.MDB;" & _ "Jet OLEDB:Database Password=MyPwd" MyConn.Provider = "Microsoft.Jet.OLEDB.3.51" MyConn.Open ConnectionString:=strConn -或- Dim MyConn As New ADODB.Connection Dim strConn As String strConn = "Provider=Microsoft.Jet.OLEDB.3.51;" & _ "Data Source=C:\...\JetPassword.MDB;" & _ "Jet OLEDB:Database Password=MyPwd" MyConn.Open ConnectionString:=strConn 如果你打開一個資料庫使用了Jet安全保護,你需要使用以下方式: Dim MyConn As New ADODB.Connection MyConn.Provider = "Microsoft.Jet.OLEDB.3.51" MyConn.Properties("Data Source") = "C:\...\JetSecurity.MDB" MyConn.Properties("Jet OLEDB:System database") = "C:\...\System.MDW" MyConn.Open UserID:="Admin", Password:="MyPwd" -或- Dim MyConn As New ADODB.Connection Dim strConn As String strConn = "Data Source=C:\...\JetSecurity.MDB;" & _ "Jet OLEDB:System database=C:\...\System.MDW" MyConn.Provider = "Microsoft.Jet.OLEDB.3.51" MyConn.Open ConnectionString:=strConn, _ UserID:="Admin", Password:="MyPwd" -或- Dim MyConn As New ADODB.Connection Dim strConn As String strConn = "Provider=Microsoft.Jet.OLEDB.3.51;" "Data Source=C:\...\JetSecurity.MDB;" & _ "Jet OLEDB:System database=C:\...\System.MDW" MyConn.Open ConnectionString:=strConn, _ UserID:="Admin", Password:="MyPwd" 注意:Jet 3.51 OLEDB provider 被設計用來打開Access97資料庫,如果你要打開Access 2000 請使用Jet 4.0 OLEDB provider,當然Jet 3.51 OLEDB provider也能打開Access 97。 如果你希望使用Jet 4.0只要將Microsoft.Jet.OLEDB.3.51換成Microsoft.Jet.OLEDB.4.0 VB连接数据库问题---急,请求高手解答 字符串处理 【问】如何做能执行VBS脚本的控件? 放弃CSDN的BLOG之后,找到一个新的BLOG,支持文件上传,还行,把IMAGECAST的模块函数公布上去了,有兴趣的朋友去看看. 求:vb高手,高高手!数据集的问题,两天了还没解决。 判断一个目录是否存在,如不存在,便建此目录,最简怎么写呀 一个小弟用SHELL解决不了的服务端调用程序,如果是高手能解决的了的话,请进来解决! GetWindowInfo怎么用? 简单问题? 在VBScript中如何强制变量声明? 散分! 本问题非常急手!!!请各为大虾、高手帮帮忙!!!、、、、、100分
Dim MyConn As New ADODB.Connection
MyConn.Provider = "Microsoft.Jet.OLEDB.3.51"
MyConn.Properties("Data Source") = "C:\...\JetPassword.MDB"
MyConn.Properties("Jet OLEDB:Database Password") = "MyPwd"
MyConn.Open
-或- Dim MyConn As New ADODB.Connection
Dim strConn As String
strConn = "Data Source=C:\...\JetPassword.MDB;" & _
"Jet OLEDB:Database Password=MyPwd"
MyConn.Provider = "Microsoft.Jet.OLEDB.3.51"
MyConn.Open ConnectionString:=strConn
-或- Dim MyConn As New ADODB.Connection
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=C:\...\JetPassword.MDB;" & _
"Jet OLEDB:Database Password=MyPwd"
MyConn.Open ConnectionString:=strConn 如果你打開一個資料庫使用了Jet安全保護,你需要使用以下方式:
Dim MyConn As New ADODB.Connection
MyConn.Provider = "Microsoft.Jet.OLEDB.3.51"
MyConn.Properties("Data Source") = "C:\...\JetSecurity.MDB"
MyConn.Properties("Jet OLEDB:System database") = "C:\...\System.MDW"
MyConn.Open UserID:="Admin", Password:="MyPwd"
-或-
Dim MyConn As New ADODB.Connection
Dim strConn As String
strConn = "Data Source=C:\...\JetSecurity.MDB;" & _
"Jet OLEDB:System database=C:\...\System.MDW"
MyConn.Provider = "Microsoft.Jet.OLEDB.3.51"
MyConn.Open ConnectionString:=strConn, _
UserID:="Admin", Password:="MyPwd"
-或-
Dim MyConn As New ADODB.Connection
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.3.51;"
"Data Source=C:\...\JetSecurity.MDB;" & _
"Jet OLEDB:System database=C:\...\System.MDW"
MyConn.Open ConnectionString:=strConn, _
UserID:="Admin", Password:="MyPwd"
注意:Jet 3.51 OLEDB provider 被設計用來打開Access97資料庫,如果你要打開Access 2000 請使用Jet 4.0 OLEDB provider,當然Jet 3.51 OLEDB provider也能打開Access 97。 如果你希望使用Jet 4.0只要將Microsoft.Jet.OLEDB.3.51換成Microsoft.Jet.OLEDB.4.0