Compress and Repair Function 1

[stotzc001]

Is it possible to put a button on a form that would force my access 2000 database to complete a compress and repair? I know I can set access to perform this option when the database closes, but I dont want it to run everytime, and I really dont want to have to explain to people at work how to go through the menu's when a database is acting up.

 

[Lightning]

In the Click event of your button, call this function:

Function DoCompression()
'Compact the current (open) Database
    SendKeys ("%(TDC)")
    
End Function

HTH
Lightning

 

[stotzc001]

Had to make one adjustment, but it works. Thanks for your help and enjoy the star.



Function DoCompression()

SendKeys ("%{T}DC")

End Function

 

[jksmi]

hi, have a look here for some alternatives to sendkeys thread705-642227