Compile error. in table-level validation expression. (Error 3320)

[Donna]

I'm using the default value Now() for a Date/Time field in a table. It has
been working fine for over a year. All of a sudden I'm getting the above
message. This happens consistently with any table - old or new- in this
database. The same default value works fine in tables in other databases.

My os is Win XP sp2. Access is 2002 sp3. All databases are using a
default file format of Access 2000.

Can anyone help me?

I've tried compacting and repairing, also copied the database. I've
searched the web & MS but haven't found an answer. I have seen lots of
discussions about 'references' and 'dlls'. I don't understand either of
those, so if my problem is in that area, I would need a VERY SIMPLE
explanation.

Thanks in advance,
Donna

 

[Brian]

I'm using the default value Now() for a Date/Time field in a table. It has
been working fine for over a year. All of a sudden I'm getting the above
message. This happens consistently with any table - old or new- in this
database. The same default value works fine in tables in other databases.

My os is Win XP sp2. Access is 2002 sp3. All databases are using a
default file format of Access 2000.

Can anyone help me?

I've tried compacting and repairing, also copied the database. I've
searched the web & MS but haven't found an answer. I have seen lots of
discussions about 'references' and 'dlls'. I don't understand either of
those, so if my problem is in that area, I would need a VERY SIMPLE
explanation.

Thanks in advance,
Donna

A broken reference, I would think. Open the VBA window (click on a form,
report or module in the database window, and then choose "code" from the
view menu). On the Tools menu, click "References". In the list that
appears, look for anything marked as "MISSING".

What you do next depends on what is missing. You can "fix" this problem by
simply removing the tick against the missing item(s), but, if it's something
your database needs, you will find that something else doesn't work
properly. You may need to come back here for more help when you know what
is missing.

 

[Donna]

Brian,

Thanks for telling me how to find missing references. At least that's no
longer a mystery. However, when I open the window 'References - Access9db'
there is nothing that says MISSING. There is a list of References with check
boxes, 4 of which are checked, that's all.

Can you offer another suggestion?

(I haven't ignored your help. I only work part time.)

 

[Brian]

Brian,

Thanks for telling me how to find missing references. At least that's no
longer a mystery. However, when I open the window 'References - Access9db'
there is nothing that says MISSING. There is a list of References with check
boxes, 4 of which are checked, that's all.

Can you offer another suggestion?

(I haven't ignored your help. I only work part time.)

Here's a little trick that may help: back in the references window, put a
tick against something that isn't already ticked. It doesn't matter what.
Close the window, then open it again and remove the tick.

 

[Donna]

That did the trick! Thanks Brian

Here's a little trick that may help: back in the references window, put a
tick against something that isn't already ticked. It doesn't matter what.
Close the window, then open it again and remove the tick.