[AccessD] Access connection to .NET?

Just as an FYI, it appears that, according to:
http://www.connectionstrings.com/?carrier=access2007

It looks like Access 2007 uses a provider as such:
With database password 
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database
Password=MyDbPassword;

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Tuesday, January 15, 2008 7:58 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access connection to .NET?

using System.Data;
using System.Data.OleDb;
...
const string accDbFileFullPath = "<fullpath to mdb>";
const string accConnection =
          "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
                             accDbFileFullPath;
...
using (OleDbConnection cnn = new OleDbConnection(accConnection))
{
       cnn.Open();
...

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, January 15, 2008 1:01 PM
To: Access Developers discussion and problem solving; Discussion of Hardware
and Software issues
Subject: [AccessD] Access connection to .NET?

After a long while connecting .NET to SQL 2000 and 2005, now I need to
connect to an Access database. Is there a built-in provider for this? Or...

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com