Backup size and original size of database different

[Guest]

I have not been able to find an answer as to why the backup size of the
database and the original database we use are different. Our administration
is concerned that the data may not be saved properly. Can someone please
give me an answer? We have not manually replicated or compacted the
database. We are using the copy command to make the backup as recommended.

Thanks for you help.

 

[Rick Brandt]

I have not been able to find an answer as to why the backup size of the
database and the original database we use are different. Our administration
is concerned that the data may not be saved properly. Can someone please
give me an answer? We have not manually replicated or compacted the
database. We are using the copy command to make the backup as recommended.

Access database "bloat" with use. Your backup file would not copy the bloat.
Have you tried compacting the source file lately?

 

[Barry-Jon]

Which file is bigger? The backup up copy or the original file? What
version of access are you using? The built-in backup database function
within access actually creates a compacted and renamed copy of the
original database. Like Rick said - Access Databases have tendency to
bloat with use. They should ideally be regularly compacted. Try
compacting the original file and then taking a backup - the file sizes
should then be very close to, if not identical to, each other.

 

[Barry-Jon]

Which file is bigger? The backup up copy or the original file? What
version of access are you using? The built-in backup database function
within access actually creates a compacted and renamed copy of the
original database. Like Rick said - Access Databases have tendency to
bloat with use. They should ideally be regularly compacted. Try
compacting the original file and then taking a backup - the file sizes
should then be very close to, if not identical to, each other.