<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>Hi
All.</FONT></SPAN></DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>I have come across
an issue in D7 where if I do the following query using the ADO Controls when
querying an Access DB, I get an error raised (at designtime) saying an exception
has occured in msjet40.dll. If I press the OK button, every thing still works
ok, and I get the results from the query.</FONT></SPAN></DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>"Select SUM(blah)
>From My Table"</FONT></SPAN></DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>Its the SUM is
doesnt seem to like or rather throws the error. COUNT etc. are fine, and it IS a
number field, not a string or text field.</FONT></SPAN></DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>The weired thing is,
it only happens at run time, and doesnt affect the exe.....that was...until I
started using an app. that uses threads, and now, it hangs the application
!</FONT></SPAN></DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>Anyone know why the
above error occurs? Do I just need to change a property to solve it
etc?</FONT></SPAN></DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546292219-14112005><FONT face=Arial size=2>Thanks,
Jeremy</FONT></SPAN></DIV></BODY></HTML>
<BR>
<P><FONT SIZE=2>--<BR>
No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.1.362 / Virus Database: 267.13.0/167 - Release Date: 11/11/2005<BR>
</FONT> </P>