[AccessD] Access XP (2002) - unknown function name date()

I am seeing an issue in a linked table where the default value is set to date().  If I view the 
table it displays #unknown for the value for the field that is supposed to be using date() as the 
default value - and the function Time as well for that matter.  If I go directly in the BE that does 
not happen, and I can add a new record.  So it is only in a linked table that this is an issue.  No 
missing references.  SP3 applied.

This kinda looks like a missing reference but that is not the case.

I am not finding this problem with a Google search.

Has anyone seen this problem?
-- 
John W. Colby
www.ColbyConsulting.com