topic Re: Connecting to ACCESS Database in QlikView

Connecting to ACCESS Database

jduenyas — Mon, 07 Jan 2013 19:17:53 GMT

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

(This was also posted in the DATABASE and CONNECTIONS forum but no answers came from there)

Re: Connecting to ACCESS Database

vikasgupta — Tue, 08 Jan 2013 05:46:21 GMT

Can you little bit more described about error if possible please share partial Access database then we can try to find out solution for same .

Thanks

Vikas

Re: Connecting to ACCESS Database

paulfiney — Tue, 08 Jan 2013 06:14:38 GMT

From the description fo your problem, it sounds like you have a secured Access database.

Within the ODBC/DSN file you may be able to add the command line switch that specifies the workgroup file (but I doubt it).

As security is an Access internal process, I seriously doubt that Qlikview, or any other product could apply the assigned security levels.

I would suggest connecting to an unsecured copy of the database, and applying security via QlikView.

Regards

Paul

Re: Connecting to ACCESS Database

jduenyas — Tue, 08 Jan 2013 17:48:52 GMT

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

Thanks to all who tried to help

Re: Connecting to ACCESS Database

jduenyas — Tue, 08 Jan 2013 17:51:59 GMT

Thanks for your reply

See "Correct answer" in my post as I found the right way. If you did not know it, you may want to acquire new knowledge.