How to connect Ms Access Database in Qlikview Script

[#1]

Hi,

I want to load Ms Access database in Qlikview Script Editor. But, when I connect to ODBC, it asks to user id and password for Data Source.

Please suggest the same that how to load such database.

Regards

Amol Khochare

[ashwanin]

Hi Amol,

Follow the thread.

Connect to Ms Access files?

[tresesco]

Have you already created the ODBC connection? If yes, you would have got an option for saving the password while created. Edit the connection string and enable that check and try again.

[#4]

Hi,

I have created the Ms.Access Database. But, while fetching the data in qlikview, it asks for User Id and Password.

Regards

Amol Khochare

[vardhancse]

once try to connect using OLE DB->Microsoft OLE DB Provider for ODBC Drivers

Click on next ->specify the source of data->enter user Id and password->test connection.

Then in script we can see connection string..

OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=(Path);Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

[vikasmahajan]

While creating ODBC  specify user and password , Then every time qv will not ask you the same.

Please see attached file.

Vikas