Prev: mantas@radesta.lt
Next: Need GardenCo database copy
From: Chuck on 3 Sep 2009 11:55
I have a 2003 database. When I execute a Compact and Repair I receive the
message "You can't exit Microsoft Access now. If you are using a Visual Basic
module that is using OLE or DDE you may need to interrupt the module."
What do I need to do? Thanks
From: Clifford Bass on 3 Sep 2009 12:08
Hi Chuck,

Hold down the <Shift> key while opening the database. That should
prevent anything from running. Then try a compact and repair.

Clifford Bass

"Chuck" wrote:

> I have a 2003 database. When I execute a Compact and Repair I receive the
> message "You can't exit Microsoft Access now. If you are using a Visual Basic
> module that is using OLE or DDE you may need to interrupt the module."
> What do I need to do? Thanks
From: Jeff Boyce on 3 Sep 2009 12:40
Chuck

Before running C&R, make a backup copy, just in case.

Just in case, make two...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Chuck" <Chuck(a)discussions.microsoft.com> wrote in message
news:6A6F1563-2EE7-4357-9D6A-3A570C30F004(a)microsoft.com...
>I have a 2003 database. When I execute a Compact and Repair I receive the
> message "You can't exit Microsoft Access now. If you are using a Visual
> Basic
> module that is using OLE or DDE you may need to interrupt the module."
> What do I need to do? Thanks


From: Chuck on 3 Sep 2009 12:51
Thank you Clifford, that worked.
Will there be a issue if I turn on Compact on Close ?
Chuck

"Clifford Bass" wrote:

> Hi Chuck,
>
> Hold down the <Shift> key while opening the database. That should
> prevent anything from running. Then try a compact and repair.
>
> Clifford Bass
>
> "Chuck" wrote:
>
> > I have a 2003 database. When I execute a Compact and Repair I receive the
> > message "You can't exit Microsoft Access now. If you are using a Visual Basic
> > module that is using OLE or DDE you may need to interrupt the module."
> > What do I need to do? Thanks
From: Clifford Bass on 3 Sep 2009 13:03
Hi Chuck,

You are welcome.

I would expect that you will have an issue with Compact on Close. You
may want to test. It may be possible that the compact will work in some
instances and not in others. So, if it works fine on first try, test it
after doing a number of activities.

Clifford Bass

"Chuck" wrote:

> Thank you Clifford, that worked.
> Will there be a issue if I turn on Compact on Close ?
> Chuck
 | 
Pages: 1
Prev: mantas@radesta.lt
Next: Need GardenCo database copy