I am compacting a database everytime it is opened with the following code: DBEngine.CompactDatabase str2Print_TDI_Path & "NewTDI_be.mdb", strTempPath
Kill str2Print_TDI_Path & "NewTDI_be.mdb"
Name str2Print_TDI_Path & "NewTDI_be1.mdb" As str2Print_TDI_Path & "NewTDI_be.mdb"
The problem I ran across is another mdb has a linked table from the mdb I am compacting. If that mdb is open the compact routine errs indicating that someone has the this database open. Is there anyway to get around this problem?
Kill str2Print_TDI_Path & "NewTDI_be.mdb"
Name str2Print_TDI_Path & "NewTDI_be1.mdb" As str2Print_TDI_Path & "NewTDI_be.mdb"
The problem I ran across is another mdb has a linked table from the mdb I am compacting. If that mdb is open the compact routine errs indicating that someone has the this database open. Is there anyway to get around this problem?