Connect Excel to Access , both saved in sharepoint, through VBA

[vineet78]

Hello

Its becoming a pain since few days.
I am trying to connect to Access database saved in sharepoint through vba

Excel is also saved in sharepoint

Code i am using is

Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & dbname & ";"
sconnect = "Provider=MSDASQL.1;DSN=Excel Files;DBQ=" & DBPath & ";HDR=Yes';"

and dbname = "URL of sharepoint"

But not able to connect to access database

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/micro...-files-both-saved-sharepoint.html#post5128132

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).