Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

berndjaegle
Contributor

Password protected MS Access file

Hi all,

have a problem connecting to MS Access.

When I open MS Access I have to provide a password.

But NOT a user.

When connectiong with QV, an interface popps up and user is filled with ADMIN.

When I enter my password it is not working.

This is the connection:

OLEDB

OLEDB CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Service-DB-QlikView1.accdb;Jet OLEDBSmiley Very Happyatabase Password="SMonly12"];

Any ideas??

Thanks,

bernd

Community Browser