Microsoft Access - Compact & Repair Database

A short video describing compact and repair in Access 2003. Additional videos to come showing this process in later versions.

Hope you enjoy, please subscribe!

---

Closed Caption:

thanks for joining us today
today man she had a compactor pair
database in Access 2003
it's a fairly simple function but should
be run regularly
in order to maintain optimal performance
review database dysfunction has a chance
to corrupt your database
even though it's supposed to improve
performance there are additional factors
that lead to that
such as folder permissions and file
size: if your fans getting very large
around to get a bite there's a chance
that it could be corrupted already just
by running a
see you gonna wanna make sure to make a
backup before doing back to repair
after major backup you gonna wanna go
ahead
and open the file with an excess in
order to do the Compact and Repair
you go to tools database utilities
Compact and Repair database sense my
database was just created
in around 10 seconds and only has one
table and one report it takes no time at
all
Compact and Repair if your files very
large this process can take quite a
while
see a green loading bar at the bottom of
the screen while compacting
even if you see access a now responding
during this process
you don't wanna make sure you let it
finish if you stop a compact repair in
the middle
there's an additional chance that your
corrupted database that really doesn't
for the compactor para now
so if you wanna see more videos like
this to subscribe to my channel
and I'll make updates frequently thanks
again for watching hope you enjoyed
that's easy