create and connect to a access database in asp.net

Connection strings for Access 2007[^]

here is the connection string.. check this one.

thanks..

The code below will be in your web.config

<connectionStrings>
        <add name="ConnectionStringName" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|DatabaseName.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
 </connectionStrings>

Now below this is how you will use your ConnectionString name in your class or code behind a page

//Method for A Database Connection
   public string dbConnection()
   {

       string connString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;

       try
       {
           // set up and open connection
       dbConn = new OleDbConnection(connString);
        dbConn.Open();

       }

       catch (OleDbException exp)
       {
          MessageBox.Show(exp.Message);
       }
       return connString;

   }

maybe u will need the following namespace

using System.Configuration;

Hope it helps...