Automating Periodic Repair And Compact

[DALIEN51]

Hi All!


I have Access 97 client and server databases linked together. My system is setup so the database is aware of how many users are currently logged in so Ill know when it is being used exclusively. What I want is some code to check every week that a repair and compact has been performed and if not start one on both the client and the server databases (assuming no one else is in them). Do I need code to delete the LDB files beforehand aswell just in case?

I kind of imagine this check will be performed when the first person logs in of a morning.

Client: rentals_prod.mdb
Server: rentals_data.mdb

Regards,

Dalien51

 

[neileg]

Is there any reason why you can't use the built in functionality of 'Compact on Close'. This will be triggered when the last person logs out, so in logical terms it's almost identical to running when the first person logs in.

 

[ghudson]

Access 97 does not have the compact on close option.

There is a freeware program called HAL that you could setup to repair and compact the db. HAL works with secured db's as well. I last found HAL at www.nonags.com

Good old Google HAL - Handy Access Launcher

 

[neileg]

Ah, thanks for the correction.