Size Size Size - and Backup Copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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