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

  • Thread starter Donna via AccessMonster.com
  • Start date
D

Donna via AccessMonster.com

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
 
D

Donna via AccessMonster.com

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
 

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. (Error 3320) 4
Unkowng function error 3320 2
Table-Level Validation 2
A table validation rule question. 6
Access Access, Error Due to Versioning Differences 0
Trouble debugging: unknown function name in table-level validationexpression 2
Date() returns "Unknown Function" error 2
default value+now() in table 1

Top