[AccessD] "Record is deleted" error

Probably as much or more work, but put memo fields in a separate table  
to keep corruption minimized and less impactful. Tends to keep the  
memo active less which helps.

Debbie

Sent from my iPhone

On May 25, 2010, at 6:51 AM, <roz.clarke at barclays.com> wrote:

> Hi all
>
> I've been asked to recommend a solution for an Access database that is
> suffering from a "Record is deleted" error several times a day.
>
> We're talking Access 2003 on Citrix, FE/BE split, 16 users using  
> 2 .mde
> FE's to access.
>
> The error is fixed by everyone exiting the database, the BE is  
> compacted
> and repaired and the offending record deleted. The PK on the main  
> table
> is often lost at the same time and has to be recreated, along with any
> relationships.
>
> A little googling suggests that the error is caused by corruption of  
> the
> record, which may in turn be caused by dropouts in connectivity  
> (that's
> not clear but as 'disk or network error' is also commonplace, I  
> suspect
> it).
>
> The table contains 2 memo fields, and some people have reported that
> these are particularly problematic viz. this issue.
>
> Apart from unbinding the form and controlling the save process in  
> code,
> can anything be done to ameliorate this?
>
> Cheers
>
> Roz
>
>
> This e-mail and any attachments are confidential and intended solely  
> for the addressee and may also be privileged or exempt from  
> disclosure under applicable law. If you are not the addressee, or  
> have received this e-mail in error, please notify the sender  
> immediately, delete it from your system and do not copy, disclose or  
> otherwise act upon any part of this e-mail or its attachments.
>
> Internet communications are not guaranteed to be secure or virus-free.
> The Barclays Group does not accept responsibility for any loss  
> arising from unauthorised access to, or interference with, any  
> Internet communications by any third party, or from the transmission  
> of any viruses. Replies to this e-mail may be monitored by the  
> Barclays Group for operational or business reasons.
>
> Any opinion or other information in this e-mail or its attachments  
> that does not relate to the business of the Barclays Group is  
> personal to the sender and is not given or endorsed by the Barclays  
> Group.
>
> Barclays Bank PLC.Registered in England and Wales (registered no. 1026167 
> ).
> Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.
>
> Barclays Bank PLC is authorised and regulated by the Financial  
> Services Authority.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>