Stevefire.mdb was getting up to 56MB in my test campaign so I tried the compact database option. It failed with a series of errors (below). It had left a backup .mdb file but I had made my own backup so I restored that and tried again. It failed again with different errors. The 2nd attempt though did not create a backup .mdb so if I had not made my own backup copy, I would have lost everything.
---------------------------
Error in CompactDB
---------------------------
Error 429 was generated by Aurora
ActiveX component can't create object
Please report to
stevewalmsley@btinternet.com---------------------------
OK
---------------------------
---------------------------
Error in CompactDB
---------------------------
Error 3024 was generated by DAO.Workspace
Could not find file 'Stevefire.mdb'.
Please report to
stevewalmsley@btinternet.com---------------------------
OK
---------------------------
There was a backup .mdb but no Stevefire.mdb after this series of errors.
Tried compacting a 2nd time after restoring Stevefire.mdb from a backup copy I had made.:
This one came up twice:
---------------------------
Error in CompactDB
---------------------------
Error 429 was generated by Aurora
ActiveX component can't create object
Please report to
stevewalmsley@btinternet.com---------------------------
OK
---------------------------
---------------------------
Error in CompactDB
---------------------------
Error 3024 was generated by DAO.Workspace
Could not find file 'Stevefire.mdb'.
Please report to
stevewalmsley@btinternet.com---------------------------
OK
---------------------------
No backup and no Stevefire.mdb after this 2nd attempt. If I hadn't made a copy, I would have been screwed.