Call SQL 2005 stored procedure from access front end

I am running this code as a pass thru query and I get incorrect syntax near tblArchivedRecords
If I run this as a code module, I get error 3146 ODBC call failed.
-- =============================================
ALTER PROCEDURE [dbo].[compareAD2SQL-tblArchivedRecords] AS

BEGIN
      UPDATE tblArchivedRecords
      SET FirstName = a.FirstName, LastName = a.LastName
      FROM tblArchivedRecords t INNER JOIN
            AD2SQL a ON t.LogonName = a.LogonName

      INSERT INTO tblArchivedRecords (FirstName, LastName)
      SELECT a.FirstName, a.LastName
      FROM AD2SQL a LEFT JOIN
            tblArchivedRecords t ON a.DSID = t.DSID
      WHERE t.DSID IS NULL

END