Trouble debugging: unknown function name in table-level validationexpression

  • Thread starter Thread starter mog
  • Start date Start date
M

mog

Friends,

My replicated database began throwing errors without my having changed
the design. The main error, when I try to open a specific table is:

"unknown function name in table-level validation expression"

There are no values or expressions in any of the field validation
properties.

I did have the expression Now() entered as a default value in a
Date/Time field. This worked to date, but Access now won't accept it.
Clearing the expression does not get rid of the first error above however.

I have run compact and repair. The database is in 2000 format. It will
not convert successfully to 2003.

Can anyone suggest a solution of a strategy to find the problem?

Thank you.

mog
 
The table-level validation is different from the Validation Rule for the
fields in the lower part of the table design window.

In table design view, open the Properties box (View menu).
The rule for the table is in there.
 
Thanks for your help. The problem was a deferenced object, causing all
sorts of misleading messages.

with kind regards,

Maurice
 
Back
Top