[AccessD] Memo field corruption

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jan 31 14:44:24 CST 2019


That's a misunderstanding of the way a memo is stored compared to other types of data.

Access uses "data pages" within the datafile to store the data.  A memo field only stores a 
pointer in the record's primary data page  which points to a separate data page (or pages)  
holding the actual memo data.

On 31 Jan 2019 at 9:28, Bill Benson wrote:

> RE:  >>> memo content is not actually stored in the table. Only a
> pointer to its location on disk is
> 
> I don't see how that is this possible. Locations on disk change all
> the time. Databases get copied from one location, partition, and from
> PC to network or to other PCs all the time, without memo fields losing
> their contents.
> 
> >
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list