Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jduenyas
Not applicable

Connecting to ACCESS Database

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)

1 Solution

Accepted Solutions
jduenyas
Not applicable

Re: Connecting to ACCESS Database

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

4 Replies
vikasgupta
Not applicable

Re: Connecting to ACCESS Database

Hi

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

paulfiney
Not applicable

Re: Connecting to ACCESS Database

Hi

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

jduenyas
Not applicable

Re: Connecting to ACCESS Database

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

jduenyas
Not applicable

Re: Connecting to ACCESS Database

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.