Repair & Restart when Docmd.Quit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bogdan - 27 Jan 2006 08:48 GMT

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

Reply to this Message

Jerry Whittle - 31 Jan 2006 17:42 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have many db and converted these over to Access2003.
>
[quoted text clipped - 7 lines]
> Thanks,
> Bogdan Vreuls

Reply to this Message