AdoConnection如何设置才能以独占方式打开 Access数据库(使别的程序不能再打开)?
*.mdb文件是否需要进行设置? 问题点数：20、回复次数：3Top
1 楼lurel（城市陌生人）回复于 2006-03-13 13:15:23 得分 10
AnsiString sConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " ;
sConnStr +="jewel.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=xxx;Persist Security Info=True";
ADOConnection1->LoginPrompt = false;
-------------------------
这里要注意
Persist Security Info=True
Top
2 楼daydayup234（关中刀客）回复于 2006-03-13 13:26:28 得分 10
__fastcall TDMOD_::TDMOD_(TComponent* Owner):TDataModule(Owner)
{
ADOConnection1->Provider=(WideString)"Microsoft.Jet.OLEDB.4.0";
AnsiString connectionAnsiString("Provider=Microsoft.Jet.OLEDB.4.0;");
connectionAnsiString+="Jet OLEDB:Database Password=***;";
//"Jet OLEDB:Database Password=***;"是 数据库密码
connectionAnsiString+="Password="";";
connectionAnsiString+="Data Source=base.dat;";
connectionAnsiString+="Mode=Share Deny Read|Share Deny Write;";
//共享独占 - 阻止其他人以读/写模式打开。
connectionAnsiString+="Persist Security Info=True;";
ADOConnection1->ConnectionString=(WideString)connectionAnsiString;
ADOConnection1->LoginPrompt=false;
}Top
3 楼minlulu（缙云）回复于 2006-03-14 13:21:41 得分 0
谢谢二位！Top
