Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jduenyas
Contributor III

Connecting ODBC to ACCESS

Hi all

When connecting to an ACCESS database i am getting a SQL error "[ODBC Microsoft Access Driver] Record(s) cannot be read; no permission on 'TABLENAME'.

How do I sepcify the WorkGroup database which will permits reading from .mdb databases?

Thanks

1 Reply
jduenyas
Contributor III

Re: Connecting ODBC to ACCESS

OK, I figuered it out. Connection to Workgroup secured ACCESS databases has to be done via OLEDB Provider for ODBC Drivers.

Follow the instructions there to create the link to the Workgroup manager and then connect to the required ACCESS database

Community Browser