Hi all,
Now I've spend hours on google without findeing a solution to this small problem.
I have a running program that uses an access database as datasource. When startet it opens the mdb in exclusive mode.
Now the problem:
I need to read (and only read) the data from the mdb while the program is running (I can't close the program while reading!).
I'm using C# and have the following connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + args[0] + ";User Id=" + args[1] + ";Password=" + args[2] + ";");
I get this error:
System.Data.OleDb.OleDbException: Could not use ''; file already in use.
If I add Mode=Share Deny Write
I get
System.Data.OleDb.OleDbException: Could not lock file.
I have full permissions to the database file and loc file.
I have no problem opening the mdb file using Access!?
Anyone have any idea to who to connect to, and read a mdb file that are in exclusive use by another program?
Thanks
- Hmortensen