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).]
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).]