Kid Code Script

' Visual Basic
Public Sub ConnectToAccess()
   Dim conn As New System.Data.OleDb.OleDbConnection()
   ' TODO: Modify the connection string and include any
   ' additional required properties for your database.
   conn.ConnectionString = & _
   "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & _
   "C:\Documents and Settings\username\My Documents\dbFile.mdb"
   Try
      conn.Open()
      ' Insert code to process data.
   Catch ex As Exception
      MessageBox.Show("Failed to connect to data source")
   Finally
      conn.Close()
   End Try
End Sub

// C#
public void ConnectToAccess()
{
   System.Data.OleDb.OleDbConnection conn = new
       System.Data.OleDb.OleDbConnection();
   // TODO: Modify the connection string and include any
   // additional required properties for your database.
   conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
       @"Data source= C:\Documents and Settings\username\" +
       @"My Documents\AccessFile.mdb";
   try
   {
       conn.Open();
       // Insert code to process data.
   }
       catch (Exception ex)
   {
       MessageBox.Show("Failed to connect to data source");
   }
   finally
   {
       conn.Close();
   }
}