如何联接有密码的ACCESS?

Question

用m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Demo.mdb","","",adModeUnknown);可以成功联接无密码的ACCESS,为ACCESS加上密码后,将上面的"",""改为"用户名","密码"却总联不上.是不程序写的不对还是ACCESS设密码有什么讲究?

Answer 1

试试这个：
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Demo.mdb","Admin","*****",adModeUnknown);
//Admin是用户名，****是密码

Answer 2

我试过以下方法,都没解决:m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=demo.mdb;USER=ADMIN; PWD=PASSWORD;","","",adModeUnknown);m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password='123'","","",adModeUnknown);m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb","UserID","Password",adModeUnknown)用udl文件
要选择记住密码，然后点击测试连接，成功后
在vc中
m_pConnection->ConnectionString = "File Name=C;\\yourpath\\yourudlfile.udl";
m_pConnection->Open("", "", "", NULL);但至今没有成功.为你顶...

Answer 3

顺便提一下,我用的密码是中文字符.如果你弄好了,告诉我一下好吗?我要是解决了,也告诉你,好不好?我的email: [email protected]

Answer 4

char buf[100];
sprintf(buf, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=零售.mdb;Jet OLEDB:Database Password=%s", strPwd); try
{
    m_pConnection->Open(buf,"","",adModeUnknown);
}
 catch(_com_error e)
{
    AfxMessageBox("密码不正确!");
    exit(0);
}

Answer 5

你到这上面看看
http://www.csdn.net/Develop/read_article.asp?id=26842

Answer 6

完整的串
"DBQ=F:\\*.mdb;DefaultDir=F:\\;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\\Program Files\\Common Files\\ODBC\\Data Sources\\DSN_*.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;;User Id=admin;"

Answer 7

to gjd111686(数字金刚) 
老大，你都写了些什么啊，我看不懂

Answer 8

m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password=PWD","","",adModeUnknown);其中PWD就是密码.也可以写成CString strConnect;
strConnect.Format(("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password=%s",PWD);
m_pConnection->Open((LPCTSTR)strConnect,"","",adModeUnknown);

Answer 9

"DBQ=F:\\*.mdb;DefaultDir=F:\\;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\\Program Files\\Common Files\\ODBC\\Data Sources\\DSN_*.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;;User Id=admin;"