access 2007链接外部加密数据库出错
下面这段代码运行报错,说是 密码无效 ,请问是什么原因?
access vb 数据库 加密
Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table
Set cat = New ADOX.Catalog
cat.ActiveConnection = CurrentProject.Connection
Set tbl = New ADOX.Table
tbl.Name = "tblClients"
Set tbl.ParentCatalog = cat
tbl.Properties("Jet OLEDB:Create Link") = True
tbl.Properties("Jet OLEDB:Link datasource") = CurrentProject.Path & "\客户档案.accdb"
tbl.Properties("Jet OLEDB:Link provider string") = ";pwd=123"
tbl.Properties("Jet OLEDB:Remote Table name") = "客户信息"
cat.tables.Append tbl
[解决办法]
参考 http://bbs.csdn.net/topics/380218637
pwd= 是用户的密码,数据库的密码应该是 Database Password=