I have an Autoexec macro in a dadabase that runs a delete query and
imports some data. It then executes an append query before opening a
table.

What I want to do in the Autoexec is:

Run delete query
Compact and Repair database
Import data
Run append query
Open table
Run other macros

However, I get an error with the compact & Repair...I can't run it
from VBA or a macro, or something like that. Also, wouold the 'Run
other macros' wait until the table was closed, or would they continnue
regardless?

Duncs

Duncs <(E-Mail Removed)> wrote in
news:1083d2aa-7eea-4fae-9c81-(E-Mail Removed)
:

> What I want to do in the Autoexec is:
>
> Run delete query
> Compact and Repair database
> Import data
> Run append query
> Open table
> Run other macros
>
> However, I get an error with the compact & Repair...I can't run it
> from VBA or a macro, or something like that. Also, wouold the
> 'Run other macros' wait until the table was closed, or would they
> continnue regardless?

Perhaps this will help:

http://trigeminal.com/lang/1033/utility.asp?ItemID=8#8

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On Feb 23, 8:51*pm, "David-W-Fenton" <NoEm...@SeeSignature.invalid>
wrote:
> Duncs <true.kilted.s...@gmail.com> wrote innews:1083d2aa-7eea-4fae-9c81-(E-Mail Removed)
> :
>
> > What I want to do in the Autoexec is:
>
> > Run delete query
> > Compact and Repair database
> > Import data
> > Run append query
> > Open table
> > Run other macros
>
> > However, I get an error with the compact & Repair...I can't run it
> > from VBA or a macro, or something like that. *Also, wouold the
> > 'Run other macros' wait until the table was closed, or would they
> > continnue regardless?
>
> Perhaps this will help:
>
> http://trigeminal.com/lang/1033/utility.asp?ItemID=8#8
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> contact via website only * *http://www.dfenton.com/DFA/

David,

Looks like a good idea but, the problme is I'd need to install
the .DLL on every PC that the database will run on. Also, it doens't
answer the question of whether I can suspend macro execution until the
table is closed.

Duncs

Duncs <(E-Mail Removed)> wrote in
news:636d0015-7ca8-488d-b79b-(E-Mail Removed)
m:

> Looks like a good idea but, the problme is I'd need to install
> the .DLL on every PC that the database will run on. Also, it
> doens't answer the question of whether I can suspend macro
> execution until the table is closed.

Well, the fact is, you can't compact a database that is open in the
UI. Indeed, there is almost no case where that is required, as users
should only ever open the front end, and front ends don't need to be
compacted (unless they are badly designed).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/