Skip to main content

    Power BI

    Needs Votes

    Add connection to password protected MDB-ACCDB Microsoft Access Database

    Vote (252) Share
    Edgar Gerardo Chinchilla M's profile image

    Edgar Gerardo Chinchilla M on 03 Nov 2015 03:46:02

    Please add support to connect to a password protected MDB-ACCDB MS Access Databse

    Comments (68)
    Edgar Gerardo Chinchilla M's profile image Profile Picture

    3b910f6a 3de3-ea11-a813-000d3a8faea9 on 22 Aug 2020 02:41:55

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    People,
    You need only use a OLE DB connection like that:
    provider=Microsoft.ACE.OLEDB.12.0;data source=DRIVE:\Path\DBAccessName.accdb;jet oledb:database password=yourAccessDBpasswordHere
    an eg.
    provider=Microsoft.ACE.OLEDB.12.0;data source=C:\Users\cw29\Desktop\2_QUARENTENA\BackEnd_BD_Desenvolvimento\BD_QUARENTENA.accdb;jet oledb:database password=burralson

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    eaeea710 ec7e-4294-b9d4-d270879af6ba on 06 Jul 2020 00:17:01

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    I made a workaround by OLEDB connection type and it works ...
    provider=Microsoft.ACE.OLEDB.12.0;data source=C:\AgendaPAM\AgendaPAM.mdb;mode=Read;jet oledb:database password=*******

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    c0b6f2d3 4ed1-44f6-ac6f-3502850d5bc5 on 06 Jul 2020 00:16:22

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Very surprised that this isn't a defacto element out the box. Its a shame it isn't.

    Absolutely essential that this gets added, ASAP.

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    ad688f90 7596-4087-9514-0f0ef82d84f8 on 06 Jul 2020 00:15:54

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    This is a paramount feature to be implemented

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    7805e5ac 3396-4911-9b84-71bc1d128181 on 06 Jul 2020 00:15:20

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    We need access to ACCESS file protected with password. Should have an authentication option to Get Access data...

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    077d5b5c 1583-46a0-8782-a627d1b028ab on 06 Jul 2020 00:13:48

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    nada que dan solución al complemento?

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    07148138 9d74-472f-aedf-960bfa74bc5b on 06 Jul 2020 00:13:35

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    we need to have access to a password protected database in Power Bi. Pl provide for the same.

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    3ced9490 038c-48bc-bb74-038aa0f8090b on 06 Jul 2020 00:13:10

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    '+1!
    Trying to vote, but there's no captcha.

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    e9dca52f ae00-4273-a560-f7c9a2a2e0e2 on 06 Jul 2020 00:12:35

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Please help us, we need this functionality....

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    639d4c8f 0d0d-4ce2-bd8c-6c1cceb04f88 on 06 Jul 2020 00:12:26

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    I strongly agree to this.