How do you (compress) reduce dbase size

  • Thread starter Thread starter MSN email and MS Outlook 2000
  • Start date 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.
 
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.
 
Thank you, I could not remember the terminology or I would have searched.
This has been very helpful and timely.
 
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
 
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
 
Kathy said:
By chance, did you ever figure this out? I'm have the same problem - my email is .
Click to expand...

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.
 
Back
Top