Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist
‎2013-01-07 01:55 PM

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

868 Views
0 Likes
1 Reply
jduenyas
Specialist
Specialist
‎2013-01-08 12:48 PM
Author

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

262 Views