I’m trying to use the Insert command to insert data from a table in one MS ACCESS DB to another MS ACCESS Database. The INSERT command works as long as there is not a password on the source ACCESS database. Is there a way to include the password for the source Database? I am using an OleDB connection.


Code:
strSQL = "INSERT INTO tbl_Headerinfo "
strSQL = strSQL & "Select * From  tbl_Headerinfo in " & "'" & StrPath & "\" & SourceFileName & "'"