Access属于文件级的数据库~~ 你就直接判断文件存在就可以了~~ if ExistsFile('c:\temp\temp.dbm') then { TODO }创建库的代码 //... var CreateAccess: OLEVariant; begin try CreateAccess := CreateOleObject('ADOX.Catalog'); try CreateAccess.Create(Format( 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s%s.mdb', [目录名, 数据库名])); finally CreateAccess := Unassigned; end; except { TODO : 异常处理 } end; end;
var vTableName: TStrings; begin vTableName := TStringList.Create; try ADOConnection1.GetTableNames(vTableName); if vTableName.IndexOf('TableName') >= 0 then { TODO : 存在 }; finally vTableName.Free; end; end;
你就直接判断文件存在就可以了~~
if ExistsFile('c:\temp\temp.dbm') then { TODO }创建库的代码
//...
var
CreateAccess: OLEVariant;
begin
try
CreateAccess := CreateOleObject('ADOX.Catalog');
try
CreateAccess.Create(Format(
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s%s.mdb',
[目录名, 数据库名]));
finally
CreateAccess := Unassigned;
end;
except
{ TODO : 异常处理 }
end;
end;
vTableName: TStrings;
begin
vTableName := TStringList.Create;
try
ADOConnection1.GetTableNames(vTableName);
if vTableName.IndexOf('TableName') >= 0 then
{ TODO : 存在 };
finally
vTableName.Free;
end;
end;
今天又学了一下判断Acess数据库表的存在,好呀