Access 2007 Connection String

Hi. I've been using Access 2003 (.mdb files) from ADO.NET for a while now.
I'd like to start connecting to the new .accdb files instead.

I've tried using the same connection string but changing the file name to
end with .ACCDB. It looks like:

ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=SomeDBFile.accdb"

But when I do this, I get a runtime error:

"Unrecognized database format 'C:\Documents and Settings\......."

Can you tell me what the connection string *should* look like?

Alex

Roger
Wed May 23 10:29:01 CDT 2007

Hello,

Have you tried to create a blank text file in windows explorer with the udl
extension, and after that double click on it ?

This shoud guide you to find the correct connection string as it will write
on that text file the correct format...

I hope it helps,


--
Roger
.NET 2005 and DB developer


"Alex Maghen" wrote:

> Hi. I've been using Access 2003 (.mdb files) from ADO.NET for a while now.
> I'd like to start connecting to the new .accdb files instead.
>
> I've tried using the same connection string but changing the file name to
> end with .ACCDB. It looks like:
>
> ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=SomeDBFile.accdb"
>
> But when I do this, I get a runtime error:
>
> "Unrecognized database format 'C:\Documents and Settings\......."
>
> Can you tell me what the connection string *should* look like?
>
> Alex
>

Norman
Wed May 23 18:31:34 CDT 2007

To connect to Access2007's *.accdb file, you cannot use the Jet engine
coming with Windows. You need to download the new Access2007 engine.

Here is the link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en


"Alex Maghen" <AlexMaghen@newsgroup.nospam> wrote in message
news:BD4FAB48-1BE3-4F83-BD61-E440726E6BC8@microsoft.com...
> Hi. I've been using Access 2003 (.mdb files) from ADO.NET for a while now.
> I'd like to start connecting to the new .accdb files instead.
>
> I've tried using the same connection string but changing the file name to
> end with .ACCDB. It looks like:
>
> ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=SomeDBFile.accdb"
>
> But when I do this, I get a runtime error:
>
> "Unrecognized database format 'C:\Documents and Settings\......."
>
> Can you tell me what the connection string *should* look like?
>
> Alex
>

v-wywang
Thu May 24 04:23:56 CDT 2007

Hi Alex,

Micosoft Jet engine doesn't support accdb file. You would have to use
Microsoft.ACE.OLEDB.12.0 to connect ACCESS 2007 accdb file.
The connection looks like
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

http://www.connectionstrings.com/?carrier=access2007
[ACE OLEDB 12.0]

However, before you start coding, please make sure Microsoft.ACE.OLEDB.12.0
has been located on your machine.
As Norman mentioned in his thread, you can download it from microsoft
website.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-
9B72-EF94E038C891&displaylang=en
[2007 Office System Driver: Data Connectivity Components]

Hope this helps. Please let me know if you still have anything unclear. I'm
glad to assist you. Have great day, Thanks
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Ken
Sun Jun 03 02:13:50 CDT 2007

Is there any way to access the accdb file using the Data Source Connection Wizard? It says it only supports .mdf and .mdb files. I can access the accdb file without any problems from my app, but I can't use the wizard to generate any typed datasets for me. Is there a workaround?

Thanks,
Ken