Discussion Board for collaboration on QlikView Scripting.
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?
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