Problem:"It is already opened exclusively by another user, or you need permission to view its data"
Posted on 2006-07-12
I'm a newbie to asp.net, and I'm facing a very anoying problem.
All I'm trying to do is connect to an access db and query some tables
I'm getting this error which doesn't makes sense to me:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'D:\mypath\db.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at UserMail.Create_Mail_Display() in ....
I'm using the same code for different scripts on the site and I don't get this message.
So obviously it can't be some script opening it exclusivly.
I have a feeling its more of a IIS setup issue.
Could someone help?