what u want ? u can dynamic create Connectionstring to Connection Any DataBase.if u want to connect access,u must dynamic config provider,Datasource,user and password. Provider=Jet4 datasource=Data File
with AdoConnection1 do begin connectionstring :='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+数据库名称+'; Persist Security Info=False; Jet OLEDB:Database Password=密码'; end;
u can dynamic create Connectionstring to Connection Any DataBase.if u want to connect access,u must dynamic config provider,Datasource,user and password.
Provider=Jet4
datasource=Data File
begin
connectionstring :='Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='+数据库名称+'; Persist Security Info=False;
Jet OLEDB:Database Password=密码';
end;
ConnStr,DBPath:String;
try
DBPath:='你的数据库数径全的';
ConnStr:='Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='+数据库名称+'; Persist Security Info=False;
Jet OLEDB:Database Password=密码';
ADOConnection1.ConnectionString:=ConnStr;
ADOConnection1.Open;
Except
ShowMessage('数据库打开失败');
end;
例:
with ADOQuery1 do
begin
ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + ExtractFilePath (Application.ExeName) + 'db1.mdb;Pe' +
'rsist Security Info=False';
end;
begin
connectionstring :='Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='+你的数据库名成+'; Persist Security Info=False;
Jet OLEDB:Database Password= ********';
actice := true ;
{
try
except
end;...............
}
end;