How do you (compress) reduce dbase size

  • Thread starter MSN email and MS Outlook 2000
  • Start date
M

MSN email and MS Outlook 2000

The size of my dbase is getting very large, there use to be a way to compress
access, I can't find it in Access 2007.
 
I

Irene

u want to do compact and repair, is it? u go to the button which hav the logo
one, u click then go to manage, then u will see the compact and repair
database.
 
M

MSN email and MS Outlook 2000

Thank you, I could not remember the terminology or I would have searched.
This has been very helpful and timely.
 
K

Kathy Garvin

M

M Skabialka

MAKE A BACKUP COPY FIRST before you do anything drastic!!!
Click the Office button, Manage, Compact and Repair database.

If you think there may be problems,
msaccess.exe /decompile "C:\Databases\MyDatabase.mdb"
Open the database, open any code module, then Debug, compile. Save changes.
Then do a compact/repair again.

Mich
 
H

Hans Up

Kathy said:
By chance, did you ever figure this out? I'm have the same problem - my email is .

In Access 2007, you can find "Compact and Repair Database" by clicking
the Office button, then choosing Manage.

The Office button is the circle in the upper left corner of your Access
window. It contains four colored squares within the circular button.
 
Top