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

Discussion in 'Microsoft Access Database Table Design' started by Donna via AccessMonster.com, Mar 17, 2005.

  1. 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
     
    Donna via AccessMonster.com, Mar 17, 2005
    #1
    1. Advertisements

  2. Donna  via AccessMonster.com

    John Nurick Guest

    John Nurick, Mar 18, 2005
    #2
    1. Advertisements

  3. 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
     
    Donna via AccessMonster.com, Mar 21, 2005
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.