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
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
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: 
Anonymous
Not applicable
‎2017-10-02 04:25 PM

Can't connect to .mdb file

I'm trying to connect to a .mdb file and I get a data link error saying "test connection failed because of an error in the initializing provider. Unrecognized database format."

The steps I'm doing are: Edit Script > Connect to an OLE DB with "force 32 bit" checked off > Microsoft Jet 4.0 OLE DB Provider

I've also tried opening the file in MS Access and I get a similar prompt saying "unrecognized database format."

Anyone know how I can connect to the file? Thanks!

1,346 Views
0 Likes
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2017-10-02 04:33 PM

Hi,

make sure you have installed the OLEDB driver for Access database.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
1,086 Views
0 Likes