connect to Access 2010

[#1]

anyone know how to connect to Access 2010?

I can only connect to *.mdb files not *.accdb.

[SunilChauhan]

press control +E -> in edit script -> click on connect-> MS access database in dialogue ->finish

now click on select-> select your table and reload

[#3]

it keeps asking me for login authorization.  it's my own personel database.  i don't have a login. 

i hit ok to bybass login and qlikview takes me back to database dialogue screen.

only .mdb file name i can connect too.  why not .accdb?

[SunilChauhan]

then you need to provide user name and password for that,because here i am able to connect without password.

[SunilChauhan]

give you file path and file name and try again with this one

ODBC CONNECT TO [MS Access Database;DBQ=C:\DOCUMENTS AND SETTINGS\SKCHAUHAN\DESKTOP\sunil\pmbr.mdb];

LOAD *;

SQL SELECT *

FROM pmbr1;

hope this helps

[#6]

that's a .mdb access db.....old version of access

i need to connect to .accdb....2007 and 2010 version of access

[#7]

figured it out...had to add new accdb driver

[#8]

HI ,

Are you able to explain how to add the accdb driver? I am havign the same problem.

thanks

dan

[#9]

HI ,

Are you able to explain how to add the accdb driver? I am havign the same problem.

thanks

dan

[#10]

adding driver depends upon ur windows....wheather its 32 or 64 bit...in 64 bit windows you will face problem.....search for SysWow64 and run odbcad32 and add DSN