Hi there,

I am trying to write a code to connect my excel userforms to my access database to launch queries from excel.
However, I get an error saying that "cntStudConnection.Open ConnectionString:=cnctSource" is not a valid file name and microsoft has no help solutions.

Here is my code:
Function QueryData(Src, OutputRange)
Dim cntStudConnection As ADODB.Connection

dbMyDatabase = ThisWorkbook.Path & "C:\Users\Hala\Documents\BBB\Dummydata1.accdb"
Set cntStudConnection = New ADODB.Connection
cnctSource = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " & dbMyDatabase & ";"
cntStudConnection.Open ConnectionString:=cnctSource

Set rstNewQuery = New ADODB.Recordset
rstNewQuery.Open Source:=Src, ActiveConnection:=cntStudConnection
Range(OutputRange).CopyFromRecordset rstNewQuery

Set rstNewQuery = Nothing
cntStudConnection.Close
Set cntStudConnection = Nothing

End Function
I am quite new to this so any help is welcomed !

Thank you