Size Size Size - and Backup Copy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hesham Sakr - 21 Jul 2007 01:56 GMT

Why does Access 2007 all of a sudden shrinks the database file size
specially when migrated form and older version??

moreover, when access stops responding, it created another file named
filename+backup which is the same but smaller in size????
can any one help?

Reply to this Message

pietlinden@hotmail.com - 21 Jul 2007 03:45 GMT

> Why does Access 2007 all of a sudden shrinks the database file size
> specially when migrated form and older version??
>
> moreover, when access stops responding, it created another file named
> filename+backup which is the same but smaller in size????
> can any one help?

If I remember right, Access builds a new database, which is empty, and
then imports all the objects, so you end up with a compacted
database. What happens if you compact the database first and then
convert? Are the sizes similar? Basically, Access doesn't actually
purge records marked as deleted until you compact the database...

Reply to this Message