Darryl Collins
Darryl.Collins at coles.com.au
Sun Mar 2 20:15:45 CST 2008
Thanks Debbie. Ok.. That could make sense. These were not just memo fields, but it is over a network which is running somewhat sluggy today and the user in question did have Access fail on them and Access generated a 'compaction error table' in the database. The error wiped out the KeyID fields and a few others and left in about half the field (say 5 out of 10) about 15 #'s and that was it. Naturally not having the KeyID immediately caused a lot of errors. I have a complete backup table which I have used to replace the damaged one with no loss of data so it is a not major issue today. It has shaken the confidence of my new users a bit. urrrgh. If anyone else has had any experience on this I would love to hear your story. regards Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of delam at zyterra.com Sent: Monday, 3 March 2008 12:52 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Table data replaced with ##### in some fields I have seen this happen on memo fields. I have been told network issues can cause them. Have not found a better explanation. Debbie Sent via BlackBerry by AT&T -----Original Message----- From: "Darryl Collins" <Darryl.Collins at coles.com.au> Date: Mon, 3 Mar 2008 12:19:45 To:"Access Developers discussion and problem solving"<accessd at databaseadvisors.com> Subject: [AccessD] Access Table data replaced with ##### in some fields Hey There, This looks like some sort of corruption issue. I have a table where two records where the data has been replaced by ####'s. Does anyone know why this may have happened? regards Darryl This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- 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 This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.