How do you (compress) reduce dbase size

[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.

 

[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.

 

[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.

 

[Kathy Garvin]

By chance, did you ever figure this out? I'm have the same problem - my email is (e-mail address removed).

Thanks,
Kathy



MSNemailandMSOutlook200 wrote:

How do you (compress) reduce dbase size
29-May-08

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.

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[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

 

[Hans Up]

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.