Insert Into works in 2007 by not in 2002 against SQL2000 and local

I have this query that when run on Access 2007 work, when run in 2002
it fails with the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect Syntax near
'.'.

INSERT INTO tblQualitySurvey ( Company, Job_Num, QS_Date, First_Name,
Customer_Number, Email, Job_Num_Count ) SELECT DISTINCTROW
Customers.Company, First(tblJobs.Job_Num) AS FirstOfJob_Num,
First(#10/8/2007#) AS Expr1, Customers.[First Name], Customers.
[Customer Number], Customers.Email, Count(tblJobs.Job_Num) AS
CountOfJob_Num FROM Customers INNER JOIN tblJobs ON Customers.
[Customer Number] = tblJobs.[Customer Number] Where
(((Customers.EMail)<> null) AND ((tblJobs.Confirmed)='Yes') AND
((tblJobs.StrikeCall) > #10/1/2007# And (tblJobs.StrikeCall) <=
#10/8/2007#)) GROUP BY Customers.Company, Customers.[First Name],
Customers.[Customer Number], Customers.Email WITH OWNERACCESS OPTION;

I know # should not work for SQL server, but it does on the 2007
machine.

The tblQualitySurvey is on SQL Server and the Customers and tblJobs
are local jet tables.

Any ideas?

Preston