Data Connection between Excel and Access (password protected) (1 Viewer)

p4nny

New member
Local time
Today, 21:48
Joined
Mar 16, 2020
Messages
15
Hi,

I'm trying to create a connection between Excel and Access. The connection will run an Access SQL query.

Only issue is the Access DB has a password. Works fine without the password.

I've tried many different options without any success. Password Encryption is currently set to legacy.

Any guidance is appreciated
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:48
Joined
Oct 29, 2018
Messages
21,358
Hi. Are you trying to make the connection via code or the ribbon?
 

p4nny

New member
Local time
Today, 21:48
Joined
Mar 16, 2020
Messages
15
Hi, I've tried both options. Found some vba that doesn't seem to work. Also tried the ribbon.

this is what I found:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Path\To\File.accdb";Jet OLEDB:Database Password="MyPassword"; I believe this goes intothe Data Connection wizard.

thanks for your reply
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:48
Joined
Oct 29, 2018
Messages
21,358
Hi, I've tried both options. Found some vba that doesn't seem to work. Also tried the ribbon.

this is what I found:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Path\To\File.accdb";Jet OLEDB:Database Password="MyPassword"; I believe this goes intothe Data Connection wizard.

thanks for your reply
Interesting, I just tried it using the Ribbon, and I had no problem.
 

Users who are viewing this thread

Top Bottom