Here is the situation: I have two servers, for simplicities sake we'll call them database-server and website-server. The database-server is to hold an Access database that we're using during development of a web application. The website server has it's own domain and is isolated from the database-server for security reasons, save for a VPN connection to the shared folder that the database is held in. I have confirmed that I can create, edit and delete files within that folder from the website-server. (The website, it's it's relevant is ASP.Net front end with VB.Net back end.)
When the database is put into the |DataDirectory| on the website server it works exactly as supposed to. However, if I modify my connection string to point at the database across the VPN, it doesn't work, saying there is either open exclusively or there is insufficient read/write permissions. It is definitely not opened exclusively.
Here is the connection string: "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\database-server\database\db.accdb;"
Things I've tried:
Tried mapping the drive. This causes a different error; that the path is invalid. Tried giving EVERYONE full rights to the database share. Tried creating a UDL file that points at the database. Something about a multi-step oledb operation generating errors. Tried using the IP address of the database-server. The VPN allows for other users to connect via it.
All resources I've read (and since I've been trying to resolve this problem for days now, it's been a lot) indicate it should work.