Compact and Repair Database

G

gear

Registered User.

Local time

Today, 01:19

Joined

Mar 10, 2007

Messages

112

• Apr 17, 2007

• #1

The compact and repair utility is very good.
Since all my record operations are done through menu, I would like to put a command button for this utility also. But I dont know how to do this. Would somebody help? Thanks in advance.

 

rainman89

I cant find the any key..

Local time

Today, 04:19

Joined

Feb 12, 2007

Messages

3,015

• Apr 17, 2007

• #2

Create a button in the onclick event put

Code:

DoCmd.RunCommand acCmdCompactDatabase
docmd.RunCommand acCmdRepairDatabase

 

P

PaulJR

Registered User.

Local time

Today, 09:19

Joined

Jun 16, 2008

Messages

133

• Jul 24, 2008

• #3

If only one person uses the database at a time, you can select the compact on close option. This can be found in TOOLS, OPTIONS, GENERAL TAB, Compact on Close.