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

Max Wanadoo max.wanadoo at gmail.com
Tue Dec 1 08:46:25 CST 2009


I suggest you compact/repair the BE with the FE closed, then relink the FE.
Max


On 01/12/2009, jwcolby <jwcolby at colbyconsulting.com> 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?
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list