[AccessD] increasing backend

Pedro, only a few records added, but were lots of existing records *changed*?  We found huge bloat even when adding just a few records but doing maintenance on many.  I read somewhere (but can't remember where) that changing data in fields on a record causes MSAccess to 'rewrite' to a different physical location and delete the origianl record.  This would make a 'change' equivalent to a 'delete' and 'add new'.  Anyone else comment?

Stephen Bond


> -----Original Message-----
> From: Pedro Janssen [mailto:pedro at plex.nl]
> Sent: Thursday, 4 March 2004 11:35 a.m.
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] increasing backend
> 
> 
> Hello Group,
> 
> how is it possible that a backend-database increases from 5 
> to 17 Mb, when only a few records are added. After compiling 
> it was again 5 Mb.
> 
> Pedro Janssen
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>