Can i ompact the current database

[Pack10]

I took over a database that imports tables from Sharepoint. It does this via code and creates a table
in the access db. Its starting to grow alot. There are 3 import processes that create this rather large table.
I would like to compact it in the middle of the process, but i don't think that works in the current open db.
What is the best approach here, this is an Access 2007 MDB. THx

 

[lameid]

First thought is you can automate access by using the opencurrentdatabase option of the appliction object.

Second is that you can use shell to compact and repair (or find a version of wait shell <one word>) that will run synchronously (wait for application to end)

Third is that you could write a function and run it in autoexec so that when you compact and repair via command line (shell) it picks up the remaining pieces.

We are missing key details like is the file split? What is causing the bloat? Perhaps avoiding the bloat is the better answer?

My thoughts are just ideas that may be incolved in a solution. You'll have to be more specific for more specific help.