Need to Compact and Repair from VBA code

[Sepop]

Hi,

I have a VBA code that deletes some old data from my database and uploads the new data into it from some excel files.

The thing is that the macro stops in the middle and brings me the error that the database reached it maximum capacity but when I click the Compact and Repair button the DB goes from 2GB to 600MB.

Is there a code to run the Compact and Repair command in the middle of the code?

Thanks!

 

[Sepop]

Some clarifications:

I am the only user of the database and I need this code to run in the middle of another code...

 

[xenou]

Your code could not run in the database itself, since you lose the execution during the compact and repair. You'd have to code this to automate the DB from another DB. Then you can:

1) Delete old data
2) compact and repair
3) now import new data

Simplest to achieve this is to set the compact and repair on close option, which simplifies the procedure to:
1) delete old data
2) close database
3) reopen database
4) import new data

 

[AOB]

xenou,

If the DB was split, you could perform the C&R from the FE? I have written code to do this, although it is a bit clunky as you have to remove the linked tables first (effectively cutting off the BE), then C&R the BE as normal, then relink the tables.

Just saying...