I am getting run-time error '3044' '\\phoenix\shared\reviews.mdb' is not a valid path.
Under the debugger, here is the highlighted text, I don't understand, because there is no path in this field...:
DoCmd.RunSQL "UPDATE Tbl_ReviewRecord INNER JOIN Tbl_MasterReviewRecord ON (Tbl_ReviewRecord.Interval = Tbl_MasterReviewRecord.Interval) AND (Tbl_ReviewRecord.Year = Tbl_MasterReviewRecord.Year) AND (Tbl_ReviewRecord.EID = Tbl_MasterReviewRecord.EID) " & _
" SET Tbl_MasterReviewRecord.TL_EID = [Tbl_ReviewRecord]![TL_EID], Tbl_MasterReviewRecord.OM_EID = [Tbl_ReviewRecord]![OM_EID], Tbl_MasterReviewRecord.Prod_Speed = [Tbl_ReviewRecord]![Prod_Speed], Tbl_MasterReviewRecord.Quality = [Tbl_ReviewRecord]![Quality], Tbl_MasterReviewRecord.Safety = [Tbl_ReviewRecord]![Safety], Tbl_MasterReviewRecord.Innovation = [Tbl_ReviewRecord]![Innovation], Tbl_MasterReviewRecord.Commitment = [Tbl_ReviewRecord]![Commitment], Tbl_MasterReviewRecord.Conduct = [Tbl_ReviewRecord]![Conduct], Tbl_MasterReviewRecord.Attendance = [Tbl_ReviewRecord]![Attendance], Tbl_MasterReviewRecord.Teamwork = [Tbl_ReviewRecord]![Teamwork], Tbl_MasterReviewRecord.Dept_Comments = [Tbl_ReviewRecord]![Dept_Comments]," & _
" Tbl_MasterReviewRecord.Above_Comments = [Tbl_ReviewRecord]![Above_Comments], Tbl_MasterReviewRecord.Below_Comments = [Tbl_ReviewRecord]![Below_Comments], Tbl_MasterReviewRecord.Gen_Comments = [Tbl_ReviewRecord]![Gen_Comments], Tbl_MasterReviewRecord.Cell = [Tbl_ReviewRecord]![Cell], Tbl_MasterReviewRecord.JobCd = [Tbl_ReviewRecord]![JobCd], Tbl_MasterReviewRecord.JobDesc = [Tbl_ReviewRecord]![JobDesc], Tbl_MasterReviewRecord.Badge = [Tbl_ReviewRecord]![Badge], Tbl_MasterReviewRecord.Writeup = [Tbl_ReviewRecord]![Writeup]" & _
" WHERE (((Tbl_ReviewRecord.Year)=[Forms]![Frm_Admin]![cmboBxYear]) AND ((Tbl_ReviewRecord.Interval)=[Forms]![Frm_Admin]![CmboBxInterval]) AND ((Tbl_ReviewRecord.TL_EID)=DLookUp('[TL_EID]','Tbl_TL','[TL] = ''' & [Forms]![frm_Admin]![CmboBxTL] & '''')));"