No I don't want to link the tables bcoz its has Credit Notes info about customers, the script which i have works well without password is as below:
Private Sub AccessCreditNotes()
Dim dbsBackEnd As Database
Dim rst1 As Recordset
Dim FileLocation As String
FileLocation =...