Maybe there's something screwy with record #525?
~~Bonnie
>The idea of cloning the application object would not be a way to resolve the issue. The reason I am saying it is because today, I am facing the "Object reference not found" error and I can simulate it at every hit. So, as this is happening on one single it, cloning the application object would not be a factor.
>
>I believe there is something wrong with the VFPOleDB provider we are using but this is not related to the first problem. That first problem has been resolved by using a global connection object for our data processing. However, I have the feeling this VFPOleDB provider is the source of this situation as well. Basically, I have an import program that import some 958 records from Excel. But, as soon as 525 records have been processed, I end up with an "Object reference not found" error. This is a loop. So, if it works once, it works for all. So, I have this error and the code is ok.
>
>This afternoon, I have been trying to find a way to workaround that issue and I just cannot. Anyone would like to share some inputs as to what I could try to resolve that issue?