Repair & Restart when Docmd.Quit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many db and converted these over to Access2003.

On of my db a huge one (0.5 / 1.5 GB) is causing some troubles. Each time
when it's finished with the macro it goes into error when I want to quit it.
At the moment the "Repair & Restart" panel is shown. You know the one in
which you can send the bug-report to Microsoft.

Does someone know why this happening and how I can prevent this ?

Thanks,
Bogdan Vreuls
 
Your database has a corruption or an Access installation problem. I would
make two copies of the database. One for safe keeping and the other to
experiment upon.

Run each step of the macro seperately. You can open the macro in design mode
and use the single step button. Find out when the error happens. If it is on
Docmd.Quit, don't do that set. Try to exit the database manually and see what
happens.

I'd also check on Tools, Options, General tab and make sure that Compact on
Close is off. While there I'd also turn off Name AutoCorrect.
 
Back
Top