本文介绍了连接到具有数据库密码的Access数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已经用密码保护了一个mdb文件,但是后来我无法在vb上访问它.我不知道定义密码的正确代码. 这是我当前的代码,我知道它是错误的,但是我也不知道正确的代码:
I've password protected an mdb file but then I cannot access it on vb. I don't know the correct code for defining the password. this is my current code, I know its wrong, but I don't also know the correct code:
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\search.mdb;pwd=nit"推荐答案
conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;"
是您的连接字符串的正确格式.
is the correct format for your connection string.
有关更多信息,请查看 www.connectionstrings/access-2007 信息.
Check out www.connectionstrings/access-2007 for more info.
更多推荐
连接到具有数据库密码的Access数据库
发布评论