Joe,

In the code you posted, the "On Error Resume Next" statement is commented out?
Is this part of you testing, or are you actually running it like this?
It should not be commented out!!

One thing that may be worth doing is firing up VBA within an office app,
producing the script within there, and then exporting to a VBS file,
Whenever I do scripts I sometimes do that so you get the benefits of a
debugger ;)

Hope this helps,
Rob

<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

Hi, Rob!
        Yes, the commenting-out of the "On Error" statement was intentional, as part of my testing.... It seems the "cnv.Convert()" isn't returning control at all when this error occurs. That's ok... I can deal with this in a whole different way, I think...

  My take on it at this point is to remove the primary key from the table so there's no attempt to filter dups, and do that after the fact with a bit of VBA code... sound reasonable? There are 2 fields (3 if I decide not to combine the Date/Time into 1 field) that will identify a record as unique. I figure that there should be a way to select unique on those 3, and more the results into another table in which NO dups are allowed... Yes?

    Thanks again for your interest in, and assistance with, this weirdness....

      Joe (should this maybe get its own thread?) Parker



JP

Joe,

Yeah its still got me confused! It sounds like you have a contingency, so it may be best to roll with that for now, and if you get the opportunity to revist then it may be worth toying with this more.. Its odd the error isn't being fed back up to the WSH. Have you tried my tip on writing the code in VBA then pasting to a script file?

As for the own thread thing, it may be worth moving this as it is now definately off-topic!!

Hope all is well,
Rob

<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>