Ok, I got a toughie. I'm normally a web guy, so services for Windows is not my thing, but I'm on the hook for this.
I have a client that runs some old software for managing their production lines. The software writes to an Access database. They have a SQL server to host the data, but it's a 64-bit installation, so it can't query the MDB directly. The client had one of the IT guys setup another Access database with some timer code in it to query the Access database and push it to the SQL Server. This works fine, but I've been tasked with converting this to a service instead.
That's all well and good. I have the queries being called. So, I wrote a service in C#. However, the service can't seem to access the UNC path to the Access database. I had the service running as local service. I've tried Network Service, as well, but no luck. I found a solution involving giving permission to a user account in AD, but the box where the file lives is not on a domain.
How can I configure the environment to allow my service to open and query the Access database?