I'm writing a Web Application that reads from an Access Database. This DataBase is written to through another Jet.OLEDB.4.0 connection from some other device I do not control. Now I was said that my web application had blocked the writing process and therefore data had been lost.
In order to make my connection really read-only I added the "Mode=Read"- portion in the connection string. This worked perfect while building/debugging my solution in VisualStudio. BUT: After deploying it to the site I get the error.
System.Data.OleDb.OleDbException: Could not lock file.
This is my connection string:
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\ESSBP1S0703\Laboratorio\Programas\UNICERT\files\Zeugnis.mdb;User Id=admin;Password=;Mode=Read;")