OLEDB Issue - No error message when the file is being used by someone

[Nandhakumar]

Hi All,

we are facing a strange behaviour from OLEDB today, let me know if anyone has faced this before ?

Issue:

Our process currently opens an excel file(excelA) and then trying to open another excel file(excelB) via OLEDB and write data. excelB file is being used by some other bot but when we open the connection via OLEDB it does not throw the exception that it is being used by someone else instead it did not throw any error and passed the stage surprisingly.

When we closed the excelA file and then tried oledb for excelB file in this case it throw the expected error message that it is being used by someone.

Note: we have to keep the excelA file opened during this process cannot close.

Thanks,

Nandha

[ManojKothapalli_G]

Hello @Nandhakumar 

OLEDB has connected to excel A and B successfully, that doesn't mean it has all the write access to both of them.

You can retrieve the data even it opened by someone else, but you cannot write/edit when it's been fully opened by someone.

[Nandhakumar]

Hi @ManojKothapalli_G ,

When you open an excel file which being used by someone else then OLEDB open connection action will throw an exception stating that "file is being used by someone else".

Yes we are aware that we can open any number of files via oledb in readonly mode even if it is being being used.

I suggest you to check the mentioned issue scenario again.

Thanks,

Nandha