Click here to Skip to main content
15,883,127 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In my application i've used Microsoft access database, now i want to use this application in a network. So that i put the database in the network and trying to access the database. But getting error
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

Here is my code:
static string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Biswa-PC\\Billing\\DB.mdb;Exclusive=1;Password=pass123;";
OleDbConnection con = new OleDbConnection(constr);
con.Open();


Please guide me how to access this database on the network.

Thanks in advance.
Posted

1 solution

When connecting to an access database with a password you should use
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Biswa-PC\\Billing\\DB.mdb;Exclusive=1; Jet OLEDB:Database Password=pass123;"

Please note the bolded part of this where you should use Jet OLEDB:Database Password and not just password in the connectionstring;
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900