求救,请问怎么连接带密码的access数据库?
我原来的数据库没有给密码,所以我如下建立连接:
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ECG.mdb ", " ", " ",adModeUnknown);
现在我加上了密码,请问该怎么写,多谢了!
[解决办法]
<PRE> "Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=; "); </PRE>
<P> If you are using a Workgroup (System database): you need to inform the
<I> SystemDB Path </I> , the <I> User Name </I> and its <I> password </I> . For that,
you have two solutions: inform the <I> user </I> and <I> password </I> in the
connection string or in the moment of the <I> open </I> operation. For
example: </P> <PRE> strConnection = _T( "Driver={Microsoft Access Driver (*.mdb)}; "
"Dbq=C:\\VC Projects\\ADO\\Samples\\AdoTest\\dbTestSecurity.mdb; "
"SystemDB=C:\\Program Files\\Microsoft Office\\Office\\SYSTEM.mdw; "
"Uid=Carlos Antollini;Pwd=carlos "); </PRE>
<P> or may be: </P> <PRE> strConnection = _T( "Driver={Microsoft Access Driver (*.mdb)}; "
"Dbq=C:\\VC Projects\\ADO\\Samples\\AdoTest\\dbTestSecurity.mdb; "
"SystemDB=C:\\Program Files\\Microsoft Office\\Office\\SYSTEM.mdw; ");
if(pDB.Open(strConnection, "DatabaseUser ", "DatabasePass "))
{
DoSomething();
pDB.Close();
} </PRE>
<P> If you want to open in Exclusive mode: </P> <PRE> strConnection = _T( "Driver={Microsoft Access Driver (*.mdb)}; "
"Dbq=c:\\DatabasePath\dbaccess.mdb;Exclusive=1; "); </PRE>
Using Standard security:
strConnect = _T( "Provider=Microsoft.Jet.OLEDB.4.0; "
"Data Source=C:\\DatabasePath\\MmDatabase.mdb; "
"User Id=admin;Password=; ");
If you are using a Workgroup (System database):
strConnect = _T( "Provider=Microsoft.Jet.OLEDB.4.0; "
"Data Source=C:\\DataBasePath\\mydb.mdb; "
"Jet OLEDB:System Database=MySystem.mdw; ");
pRs.Open(strConnect, "MyUsername ", "MyPassword ");