default value expression not recognized also error # 3320

Question

default value =Now()  response is "The expression you entered has a function name that "database" can't find.  The suggestion was that I needed to allow my database folder to be seen in a trusted directory which I have done.  It is in a shared group.  The data default date/time has been entering properly but the table data is giving errors on entry now of #3320 and I am trying to solve this.

Answer 1

#3320 is a table validation error.

Here is a link on setting up table validation:

http://www.allenbrowne.com/ValidationRule.html

Do you have a validation rule =Now() for a date field in a table?

Is this giving error 3320?

Perhaps you have a problem with the references in this database.

Open the code window and click on Tools | References.

You will need:

Visual Basic for Applications

Microsoft Access 14.0 Object Library

Microsoft Office 14.0 Database engine Object Library