I'm guessing that even though you think you have error handlers in all your
modules, you're missing one in at least the spot that this error occurs.
Can you reproduce this error consistently?
Are you saying that performing the same steps in the Development
Environment, you cannot reproduce this error?
The error means that the variable or property that you are trying to put
some data in doesn't not accept the datatype of the value you are trying to
put into it. Most of my errors of this type surround date/time datatypes
but maybe you just declared one incorrectly. I would suggest going through
your application again to make sure you have error handlers everywhere, and
when you find the spots that don't have it, putting one in will help you
narrow down where that error is occuring so you can scrutenize your
datatypes that are used in that section.
> I get this error from time to time when running my compiled VB app and my
> app crashes. I'm using VB 6.0, SQLServr 2000, MDAC 2.5 and who knows
> else. I have error handlers in all my modules but this doesn't seem to be
> trapped. I use mainly stored procedures and I suspect it might have
> something to do with errors generated by SQL that aren't handled by VB.
> anyone give me any advice here. Upgrade to MDAC 2.6 or 2.7?
> Tom H