Access database engine cannot open or write to the file

Question

Dear All, 

I have created package in SSDT and I can execute package in SSDT -  load data in excel to sql database - it works. However after deployment to server it does not work, I have following error:

"An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "The Microsoft
Access database engine cannot open or write to the file '\\KKK001\TEST\Template.xlsx'. It is already opened exclusively by another user, or you need permission to view and
write its data."

In job there is a proxy user which have access to the excel file. 

Apart from job I have tried to execute the package from Integrated Service Catalog, so from my user (I have also access to excel file) and can see the same error. 

Can you help with the issue? 

Answer 1

Are you sure that the file is not opened? 

Answer 2

yes, I checked it is closed :/ 

Answer 3

Hi John8522,

"An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "The Microsoft
Access database engine cannot open or write to the file '\\KKK001\TEST\Template.xlsx'. It is already opened exclusively by another user, or you need permission to view and
write its data."'

Please give the user read and write permission to the excel file.

Best Regards,

Mona

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

Thank you Mona

The user has access to the whole folder and he excel file as well read/write/modify, so this is rather not the case :(

I have tried adding access to Everyone User to file and folder, unfortunately no change, error is the same.

Answer 5

John,

Change the design to copy the file over to a local disk then process with the package.

---

Arthur

MyBlog

Twitter

Answer 6

Hi Arthur,

I tried copying the file to server however I have following error: 

Copy File:Error: An error occurred with the following error message: "Access to the path '\\KKK001\TEST\Template.xlsx'. is denied.".

That's strange as I have all rights, to proxy users, I have added even read/write access to Everyone User ... 

Thank you 

John

Answer 7

Then the proxy does not have the necessary rights. Fix that.

---

Arthur

MyBlog

Twitter

Answer 8

That was really strange, after 2 days it just started working...

Anyway it works, just little worried that I still don't know what caused the problem.

Thank you all for support!