Pnina Alon

Pnina Alon

  • NA
  • 1
  • 1.6k

Problem conection to server .mdb database in windows service

May 17 2013 2:08 AM

Hello,
I wrote windows service in c# that connects to access database and make few operations with the data.The problem is that when i try to connect to server database , like \\10.10.10.10\data\data.mdb i get error (i write it to text file ) :
The Microsoft Jet database engine cannot open the file '\\10.10.10.10\data\data.mdb'.  It is already opened exclusively by another user, or you need permission to view its data.

I tried everything - i gave all existing permissions to that database , i tried to run the service as Network service instead of Local system , i searched in the forms , but i don't find any solution.
Please help with with this issue.
I have other issue , also related to windows service - i try to produce excel file from windows service - but it always throws unknown errors , something like com object (i don't remember exactly) , but in regular windows application it produces excel file.