Connection with MS-Access
I have made connection with MS-Access
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Path:\\File.mdb";
cn.Open();
Response.Write(cn.State);
Now if I run from localhost works fine. However if I run it from IIS geberates an error:
Server Error in '/Comp' Application.
--------------------------------------------------------------------------------
Could not use ''; file already in use.
What should I do?
Pls: The connection is working for MS SQL server
Re: Connection with MS-Access
From memory this error is usually caused by a lack of permissions on the .mdb file. Is the file in the App_Data folder and what permissions does asp.net have on this folder.
You could google your error ....... Could not use ''; file already in use.
Re: Connection with MS-Access
you mab need to Impersonate user in web.config file
Code:
<identity impersonate="true" userName="domain\user" password="password" />