[AccessD] Memo field corruption

[Daniel Waters]

I always include memo fields in the same table.  I haven't heard of what you described - have you seen that done somewhere?  

Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: January 26, 2019 10:17
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Memo field corruption

When you include a memo field, do you include it in the table or do you
relate to a second table that stores just the memo field? 

Susan H. 


Hi Susan,

I've used memo fields extensively and never had a problem I could attribute
to a memo field.

One thing I do to keep an access file healthy is to always check 'Compact on
Close' in Options under Current Database.

This is a good description here:
https://www.fmsinc.com/microsoftaccess/compact/compact-on-close.html

Good Luck!
Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: January 26, 2019 9:35
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Memo field corruption

I can't say that I've ever truly needed one, not after giving the request
good thought. So, I don't have much practical experience. 

Susan H. 


I can't say I ever experienced it, but I have always used them sparingly,
maybe one per table.

Charlotte Foust

On Sat, Jan 26, 2019, 7:17 AM Susan Harkins <ssharkins at gmail.com wrote:

> Is corruption still an issue with Access memo fields?
>
> Susan H.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com