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
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