[MarshaR]

Hi,
I'm new with vb.net and I'm currently doing a project that includes access 2010

My question will be what driver can I use for an access 2010 *.accdb type file?

For a *.mdb it works perfectly well with

 ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
 

But, when I changed the mbd to accdb:

ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"

It resulted in errors:

ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'

And then it shows me that my code for

If dsLogin.Tables(0).Rows.Count = 1 Then 

IndexOutOfRangeException was unhandled
Cannot find table 0

I knew it must be the driver but I don't know what accdb driver I can use for the connstring.

This post has been edited by MarshaR: 08 October 2011 - 05:42 AM

[raziel_]

I think your driver dont support new access format. why dont you just use the old format?

[MarshaR]

Because I have to use an accdb file instead of a mdb file for my project as the task.

[raziel_]

try this connection string then:
http://www.connectio...com/access-2007