执行:
ADOQuery1.Close;
oJetEng := CoJetEngine.Create;
if FileExists(FilePath+CPHeadDBName) then
begin
sOldMDB:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+AppPath+'\'+FilePath+CPHeadDBName;
sNewMDB:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+AppPath+'\'+FilePath+'~'+CPHeadDBName;
oJetEng.CompactDatabase(sOldMDB, sNewMDB);时报该错误。FilePath+CPHeadDBName是Access数据库文件,被ADOQuery1连接打开过。创建时:
if not(FileExists(FilePath+CPHeadDBName)) then
begin
tmpBasStr:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+AppPath+'\'+FilePath+CPHeadDBName;
CreateAccess:=CreateOleObject('ADOX.Catalog');
CreateAccess.Create(tmpBasStr);
end;
ADOQuery1.Close;
oJetEng := CoJetEngine.Create;
if FileExists(FilePath+CPHeadDBName) then
begin
sOldMDB:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+AppPath+'\'+FilePath+CPHeadDBName;
sNewMDB:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+AppPath+'\'+FilePath+'~'+CPHeadDBName;
oJetEng.CompactDatabase(sOldMDB, sNewMDB);时报该错误。FilePath+CPHeadDBName是Access数据库文件,被ADOQuery1连接打开过。创建时:
if not(FileExists(FilePath+CPHeadDBName)) then
begin
tmpBasStr:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+AppPath+'\'+FilePath+CPHeadDBName;
CreateAccess:=CreateOleObject('ADOX.Catalog');
CreateAccess.Create(tmpBasStr);
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货