Connection with MS-Access

[Abbas Haider]

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

[brin351]

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.

[riteshjain1982]

you mab need to Impersonate user in web.config file

<identity impersonate="true" userName="domain\user" password="password" />