I have recently has some trouble exporting QA summary and QA error reports from ESdat.  A number of people who have been using ESdat in my office recently have experienced the same problem.  It occurs when you go into the QA checker option of the reports button, then select export all data, QA summary and QA errors.  ESdat then begins to formulate the report but stops when it gets to the 'checking field duplicates' part and comes up with an error message that says 'general ODBC error'.  If you click ok on this error it will still produce the QA report but in the field and interlab dup page the results do not actually come up.  If you go back and select 3-4 sample batches at a time it will export them no problem so we have been getting around the problem that way, but it seems that ESdat can't export all of the data at one time without an error occuring.  We are all running ESdat version 3.7.46 and have recently upgraded to the microsoft office 2007 package.

Is anyone else having this issue?  Is it a problem with ESdat or compatability with office 2007 possibly?  Any suggestion as to how this can be solved would be appreciated.