Hello

I have a table within my large database application (one of the main tables) and some of the records keep doing strange things, characters such as: '佀渀攀 䌀愀氀氀 㐀 䌀愀爀 䌀愀' keep appearing and it splits the fields and mixes them all up. I presume they are corrupt records. Without having to create a new table and importing all the data in to a new table (there is a lot of data and this application is used throughout the normal working day - all day) is there any easy way out? Has anyone else had this problem? Is it something I have done which has caused this or is it a problem with Access?

Many thanks

Paul S

See if there is anything in this link that helps: Preventing corruption (http://allenbrowne.com/ser-25.html)