 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 2) |
| Author | Comment |
Paul Brassett
Oct 12, 05 - 3:26 PM |
MARS isn't compacting on exit ... database keeps getting bigger
The MS Access database which MARS is accessing for my reports keeps getting bigger and bigger. I have the database set to "compact on close" and this works when I run the db manually. How can I get MARS to compact the database? |
|
Mars Support
Oct 12th, 2005 - 3:50 PM |
Re: MARS isn't compacting on exit ... database keeps getting bigger
There is no functionality within MARS to do housekeeping work on the source database. You can write a batch file on the PC that the database is stored on to open Access using the \compact command. This will open Access, compact the database and close Access. Schedule the batch file with Windows Scheduler to execute a regular intervals or set times. This process will not work on the PC that has MARS running on as MARS. This is because MARS keeps the connection open between report executions as otherwise the constant opening and closing of connections can cause corruption ( a known Access problem). So you will need to run the batch file on a different PC. We are looking to add this functionality into a future version of MARS. 
|
| First |
Prev |
Reply |
Forum |
Next |
Last |