Cannot open connection to Access Database.

I am very new to VB.Net but my goal is to build a web app that ineracts with an Access database. This is a very small scale app so I am not interested in using SQL server. I created my Access database and the udl file for connection information.

I created a class that opens a connection to the database when the webpage loads.

I get the following error though,

System.Data.OleDb.OleDbException was unhandled by user code
ErrorCode=-2147467259
Message="The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\Test1\RaceData.mdb'. It is already opened exclusively by another user, or you need permission to view its data."
Source="Microsoft JET Database Engine"
StackTrace:
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 clsDBConn.Open_Connection() in c:\inetpub\wwwroot\Test1\App_Code\clsDBConn.vb:line 12
at Default2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\Test1\Default2.aspx.vb:line 8
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

The database is not open so I know it is a matter of security. I have configured IIS to use an admin account and the Access db does not have security turned on. In the UDL file I have selected read/write access and the test connection works.

Can anyone help me narrow down the root of this error,

Thanx in advance,

Chris

Topfuel5

Hi,

The Error is self descriptive that means either you don't have proper privilege or the file is either opened in Edit Mode refer below links for work around

http://support.microsoft.com/kb/174943 & http://www.xlinesoft.com/asprunner/docs/error_the_microsoft_jet_database_engine_cannot%20open%20the%20file%20(unknown).htm

Hemantgiri S. Goswami