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

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

--
Message posted via http://www.accessmonster.com

Hi Donna,

This sounds like a references problem. See
http://www.accessmvp.com/DJSteele/Ac...nceErrors.html
for full instructions.



On Thu, 17 Mar 2005 20:58:12 GMT, "Donna via AccessMonster.com"
wrote:

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Thanks John.

Since I only work part-time I just got your answer.

The problem was in a module I had. I'm not sure what the problem was, but
deleting references and adding them back corrected it.

I also learned a lot about referces from the web page you pointed me to.

Thanks again,
Donna

--
Message posted via http://www.accessmonster.com