Hi Guys,

I have connection string like below:

DSN=MS Access Database;DBQ=C:\Users\ljar01\Desktop\Makro Braki Access\Nowy\Aplikacja_Braki_FE.accde;DefaultDir=C:\Users\ljar01\Desktop\Makro Braki Access\Nowy;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
This is working when in SQL command there is :

SELECT * FROM tbl_Braki
Now 2 things:
1. When i have password on my split database it is not working, where can I put the password in connection string?
Better is using DSN or Microsoft JET?
2. I want to create connection between Excel worksheet and Access Query, not table, it is possible?


Bez*tytu?u.png

Please help Guys,
I didn't find the solution in internet,
Best wishes,
Jacek Antek