Size Size Size - and Backup Copy

H

Hesham Sakr

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?
 
P

pietlinden

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top