Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
anyone know how to connect to Access 2010?
I can only connect to *.mdb files not *.accdb.
press control +E -> in edit script -> click on connect-> MS access database in dialogue ->finish
now click on select-> select your table and reload
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?
then you need to provide user name and password for that,because here i am able to connect without password.
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
that's a .mdb access db.....old version of access
i need to connect to .accdb....2007 and 2010 version of access
figured it out...had to add new accdb driver
HI ,
Are you able to explain how to add the accdb driver? I am havign the same problem.
thanks
dan
HI ,
Are you able to explain how to add the accdb driver? I am havign the same problem.
thanks
dan
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