Compacting Database on Exit or Schedule

[NOPOPNOSTYLE]

Hello there

Could anyone supply me with the Code I would need to get my Access Database to Compact and Repair itself upon Exiting, or better still a code that would allow myself to pick a time to schedule such activity, prehaps to ones bios clock for example.

Many Thanks

Lord Exell

 

[Junior1544]

personaly, i don't like to have things like compacting happen automaticly because if there's an error, you'll never know it...

i will look into the code needed to do this for you, but make sure to think about the possability of error's befor doing it...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[mp9]

Why not just use something like the Handy Access Launcher to do all this for you? It's freeware and is available from

http://www.geocities.com/waddly/accory.html

http://www22.brinkster.com/accessory/