Error 3275 While Exporting The Data?

I have fronend and backend database. I have all data stored in another database (backend) and that database is password protected. I need to export some selected data into Excel which is created in the same process. Below is the code:

Code:
Private Sub ExportLeaversList(strWorkbook As String)
On Error GoTo ERR_HANDLER
Dim objApp As Object
Dim strExcelFileName As String
Dim varStatus As String
Dim strTempQueryName As String
Dim strSelectSQL As String
Dim strPnPDatabaseName As String
Dim strPnPDatabasePassword As String

[code].....

I'm getting error at below line

.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strTempQueryName, strWorkbook, True

Run-time error '3275':Unexpected error from external database driver (1309).