I have an application that creates an email (using Access VBA) saves it as a temporary MSG file then sends it. The MSG file is stored in SQL Server 2000 as an image data type (using ADO Stream). The email can then be retrieved at a later date and viewed from the database (thus any user can view it).
I have this application on a number of sites and it has been running successfully for around 3 years.
One of my clients has started experiencing a problem whereby the msg file when retrieved from the database is corrupted and cannot be opened. When the MSG file is opened in notepad, the message header seems to be there but not the body.
I use this method on all sorts of different documents (e.g. Word, Excel and JPG images) and it doesn't seem to have happened with any other document types.
The only obvious difference between this client and my others is that they are running using Citrix.
Has anyone experienced this kind of problem before or do you have any ideas what might be causing it and how I might resolve it?
Thanks.
Start Free Trial
