disappearing data

I am not sure where to put this but correct me if i'm in the wrong forum.

I've been working on this database for some time now. It's an Access 2003 database with a SQL backend. Everything was going well until one of the users noticed her data was disappearing after she send an email. The database has a memo field that gets pasted in the body of an email when it is created. Sometimes, when the user sends an email and goes back into the record, the memo field is blank. I know the field has data in it at the time of the email because it will give you an error if the field is null and you won't be able to send it. And, it goes into a history table with everything the user does with each record. I've checked this history table and it shows that all records in question, an email was sent. I have no idea why the data would disappear in this field. It does not happen all the time. I've performed the same steps and I can't duplicate the problem. There's no code associated with the memo field that deletes it after sending the email. Can anyone think of anything that would cause this?

I guess the user is doing STRG-X instead of STRG-C ?! Although I also had the feeling that Access sometimes eats up the data in the past, there was always a possible explanation why the data was lost.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||I don't know what that is?|||Hi,

you mentioned that the data from the record is pasted into an email, this sounds like manual work for me, so i suggested that they do that on their own and not doing it automatically with an application. Therefore I assumed that they might not copied the data (STRG-C) from the memo field as they cut the data (STRG-X) from the memo field to paste it (STRG-V) within the email. Did I understand you right, or what is the actual problem ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de