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

Sorry I didn't post back.  A decompile fixed this problem.

John W. Colby
www.ColbyConsulting.com


jwcolby wrote:
> 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?