Database Utilities: Compact and Repair

[ctaylor]

Is there a way to programatically schedule a compact/repair operation?

I would like to use the windows scheduler to open a database whith a compact/repair operation.

Alternately I would like to add this utility function to the autoexec macro.

=========================
I have a couple of databases which make lots of Btrieve ODBC calls to huge tables (containing hundreds of thousands of records). I believe that the constant ldownloading of these huge tables, as well as the running of delete/append queries (to create temp tables to speed up access performance) somehow corrupts. I know for sure that the MS Access application stops functioning every couple of weeks unless it gets compacted/repaired.


[This message has been edited by ctaylor (edited 04-18-2001).]

 

[MHM]

This is really difficult, because when calling something like "...compact..." Access always asks for a new file name.

We've solved this by calling Sendkeys ..., although cursor and mouse get locked. Yet it's still better than doing RunCommand or DoCmd.

Mic

 

[ctaylor]

I just found mention of a

DBEngine.CompactDatabase method

for MS Access 2000 which I have never heard of before. Have you ever used this?

Can this method be integrated within a run-time distribution of Access 2000?

Does anyone know if this utility will run if another user of this database has a record open?

[This message has been edited by ctaylor (edited 04-18-2001).]

 

[Peter D]

Here's something that might help:

"Compact A List" is a free MS Access database that allows you to backup, repair, and compact a saved list of Access database files. It also saves the results of these actions in a table for later viewing, making it suitable for batch or scheduled execution.
http://www.peterssoftware.com/cal.htm

Also, there's a nice utility from Calvin Smith called "CompactIt" at:
http://home.sprintmail.com/~calvinsmith/compact.htm

You can also use the TSI SOON utility to close a database, compact it, and then open it again:
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8

Here's some more information about reducing database size:
http://www.peterssoftware.com/t_dbsize.htm

Hope this helps,

--
Peter De Baets
Peter's Software - MS Access Tools - http://www.peterssoftware.com