[dba-Tech] Access connection to .NET?

Bobby Heid bheid at sc.rr.com
Tue Jan 15 16:38:31 CST 2008


Arthur,

You would use OleDB (preferable) or ODBC.

Here's the info for Access 2007:
http://www.connectionstrings.com/?carrier=access2007

ACE OLEDB 12.0 
 
Standard security 
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

With database password 
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database
Password=MyDbPassword; 

And for other versions of Access:
http://www.connectionstrings.com/?carrier=access


Bobby


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, January 15, 2008 5:01 AM
To: Access Developers discussion and problem solving; Discussion of Hardware
and Software issues
Subject: [dba-Tech] 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





More information about the dba-Tech mailing list