ms access 2000 database bloat

  • Thread starter Thread starter sandy gallo
  • Start date Start date
S

sandy gallo

my access databaseseems to grow much larger than the input
files should make it grow. any ideas? thanks,
 
File space used by deleting records or objects in an .mdb
file is not reclaimed and made available again.

To get around this, click on "Tools | Database Utilities
| Compact and Repair Database...". mdb files need to be
periodically compacted. You can read the help files for
detailed instructions on compacting.

Also, I know in Access 2002 (not sure about 2000), you
can click on "Tools | Options...", click the "General"
tab, and check the "Compact on close" option if you want
it to compact every time you close it.

If you want even more control over when a database is
compacted, you can use the following VBA method as well:

DBEngine.CompactDatabase olddb, newdb, locale _
,options, password

Fill in the variables, put it in a function, and run it
at the event of your choice. Again, you can look up the
help for the CompactDatabase method for specific details.

HTH
Joel
 
1. Do regular Repair and Compact on the database.

2. Don't store any graphic in the database, even for .jpg files.
 
Back
Top