Compact and repair/ close access 2016

[Simonhtc4]

hope this helps anyone here,

VBA to compact and repair then close access.

Private Sub CloseFormcmd_Click()
SendKeys ("%T D C")
DoCmd.Quit




End Sub

[jwhite]

Avoid any use of Sendkeys.

And there is a setting option to automatically compare/repair the database on close.

[Simonhtc4]

i didnt know the, can you show me were that feature is please, i could only find to close the database and not the whole of access.

[Simonhtc4]

Doh i found the setting thank you for the advice :-)

[jwhite]

http://www.fmsinc.com/microsoftacces...-on-close.html

[aytee111]

Avoid any use of Sendkeys

Please explain.

[Simonhtc4]

http://www.fmsinc.com/microsoftacces...-on-close.html

ThanksJwhite:-)

[CJ_London]

@aytee - basically because sendkeys is unreliable, particularly in a production environment, and does not respect which application window it is in - so user might inadvertently change focus to another app/window and the keys will be applied there instead - possible with disastrous results.

[aytee111]

Thanks, Ajax, great explanation.