suggest debugging strategies for "unknown function name in table-levelvalidation expression"?

  • 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
 
Thanks for your reply.
I just checked and there no table level validation rules. This is
strange. I get the same errors on two machines. The errors just seem to
have started. I haven't tampered with the design.

m
 
Hve you checked that this isn't a problem with a Validation Rule for the
table itself and not just the fields (open the table in design view - right
click the title bar - hit properties)?
 
Hi,
Thanks for your reply.
I just checked and there no table level validation rules. This is
strange. I get the same errors on two machines. The errors just seem
to have started. I haven't tampered with the design.
Click to expand...

Check the references in VBA-Editor.
Are there 'missing....'?

Acki
 
mog said:
Thanks for your reply.
I just checked and there no table level validation rules. This is
strange. I get the same errors on two machines. The errors just seem to
have started. I haven't tampered with the design.

m
Click to expand...
 
Jorg, thanks for the reply. I think that was the problem. The Office
library had become dereferenced, and that deferencing may have been
propagated across machines as the db was referenced. It caused many
confusing and disturbing effects along the way, including "no memory"
messages and repeated crashes.

The problem is solved, but for my and any other reader's edification,
how could I have identified the missing reference problem more quickly?
I found it by trying to compile the code and then trying to click on a
suspect object in the F2 object browser: I got a message saying "cannot
open, library is not referenced".

Is there a faster way? From the messages it appears there is.

But my immediate problem is sorted. Thank you for your kind help.

mog.
 
Back
Top