Power BI
Needs VotesAdd connection to password protected MDB-ACCDB Microsoft Access Database
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 (73)
RE: Add connection to password protected MDB-ACCDB Microsoft Access Database
This should be a standard feature, as it's all basic Microsoft functionality.We have many old-fashioned databases in Access, that we are not going to move fully online and the lack of this connector adds a lot of work to our employees.
RE: Add connection to password protected MDB-ACCDB Microsoft Access Database
We need this feature available urgent. Please, Microsoft, help us.
RE: Add connection to password protected MDB-ACCDB Microsoft Access Database
After searching high and low for a solution on how to achieve connecting to a password protected Access database, I finally came across this post detailing how it still is not supported. This truly would be very helpful for myself and my organization in being able to enhance reporting capabilities. Disappointed that this seemingly obvious feature still does not exist.
RE: Add connection to password protected MDB-ACCDB Microsoft Access Database
We need this feature available urgent. Please, Microsoft, help us.
RE: Add connection to password protected MDB-ACCDB Microsoft Access Database
I see comments about a workaround and using an OLE DB connection. My database is in SharePoint - will this work if not in a drive and if so, how? Thank you.
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
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=*******
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.
RE: Add connection to password protected MDB-ACCDB Microsoft Access Database
This is a paramount feature to be implemented
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...