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?
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];
SQL SELECT *
hope this helps