I'm tring to give my C# program read only access to an MDF file stored on a remote drive, which is getting written to by another process on the remote machine. When my code reaches the Open() call, it throws an exception. The drive is a read-only drive.
The code I use is:
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +@"Data source=" + "Y:\history.mdb";
The exception says that the file is already in use. What could be wrong? Any ideas about what I could try?