Help with adding new field

[Al]

I am getting the follwoing error messages when I try to add new field to a
table:
"Function is not available in expressions in table-level validation
expression"
"Errors were encountered during the save operation"
I compacted and repaired. I am still getting the same thing. any idea?
thanks
P.S. I work in Access 2002
Al

 

[JackP]

Can you give us more info about the field you're trying to add- what it's
called etc, as well as confirming that you've got update access to that table
design (will it let you change other field names, for example?)

 

[Jeff Boyce]

Also, are you using the <design> interface, or trying to add a field via
SQL?

Jeff Boyce
<Access MVP>

 

[Al]

Can you give us more info about the field you're trying to add- what it's
called etc, as well as confirming that you've got update access to that table
design (will it let you change other field names, for example?)

I am the admin, so I should not have any problem adding or modifying. the
field is just a Plain text field with default of "UNK". I have been adding
fields to this table without a problem.

 

[JackP]

I'm assuming (like Jeff says) you're using the access design interface. It
also appears that you have design permissions to the table, if you can change
other stuff. It may be therefore that it's just this field that's the problem
- try it with a different name, a different datatype, a different input mask,
validation rule etc.

If you can't add new fields at all , it's the table or your permissions.
If you can add new fields - just not this one - it's something to do with
what you're trying to add. So change the values one by one until it works -
particularly for
Name, Datatype, Format, InputMask, Caption, ValidationRule, ValidationText