Trouble debugging: unknown function name in table-level validationexpression

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
 
A

Allen Browne

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.
 
M

mog

Thanks for your help. The problem was a deferenced object, causing all
sorts of misleading messages.

with kind regards,

Maurice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error. in table-level validation expression in append query 0
Compile error in table level validation expression in ms access office 2019 0
"Compile error in table level validation expression " after format 0
suggest debugging strategies for "unknown function name in table-levelvalidation expression"? 5
Date() returns "Unknown Function" error 2
table level validation 1
I keep getting an "Unknown function "CurrentUser()" error 3
Table-Level Validation 2

Top