glycere2000 (6/5/2013)
Can you say what other specifics you need? This particular function has been working well for years and only about couple of months i realized this has happened sporadically. That's why i was wondering if its my interaction with the database.
there's a lot of combined talent with all the volunteers that look at this thread, so the more detail you can provide, the more we can help.
lets see the vb6 function; maybe after years it's hitting the 32767 VB6 Integer limit, and the code is rolling over and creating repeats;
that's just a guess, but one possible explanation.
remember all i can tell about the issue, is what you post here; you've got the insiders look at the issue, but also insider assumptions that we know what you see, but we really can't; you have to post it here for us to see it too.
Lowell