compacting a database automatically

[Wieczoreck]

Hi everybody!

Who can help me?
I want my database to be compacted everytime when it is closed.
Somebody told me about a prog called "JetComp", but unfortunately one file (msjet40.dll) is missing. Does anyone have this file, knows a similar program or another way?
I am using Access97.

Thanx a lot!
Daniel

 

[CosmoKramer]

From Access 2000 help:

Microsoft Access can automatically compact a Microsoft Access database or Microsoft Access project every time you close it. 

Open the Access database or Access project that you want Microsoft Access to compact automatically.


On the Tools menu, click Options.


Click the General tab.


Select the Compact On Close check box.

 

[Wieczoreck]

Hello!

Your are right that there is acheckbox in Access2000, but I am using Access97. The checkbox doesn't exists in this version. Any other possibilities?

Daniel

 

[CosmoKramer]

Sorry, my bad...I skipped right over that. Take a look at this MS web site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q158937

(Article ID:Q158937)

I don't know if this will help or not......

 

[Quintios]

You have to manually do it in Access 97, as far as I know. I have two macros that I've attached to buttons that can make the procedure quick and painless.

Macro Name:  mCDB  (Compacts the Database)

Macro Command  SendKeys
Keystrokes     %(TDC)
Wait           No

Macro Name:  mRDB

Macro Command  SendKeys  (Repairs the Database)
Keystrokes     %(TDR)
Wait           No

Like I said, you have to do this manually. I'm sure you searched through the Tek-Tips forums for information on this topic, right? There could be another way, but this, honestely, is the easiest.
Onwards,

Q-