Error 3799 Field name not found

[Guest]

I had put a field name (FUPDate) in Table 1 but decided that this field need
to be put in Table 2; so I deleted from T1 and put in T2. I never referenced
this field anyway but everytime I open T1 to make a design change and click
on Save I get an error msg "Could not find field name FUPDate" and when I
click OK I get another error msg "Errors were encountered while doing save
operation." (If I were to click on the help button instead of OK it reads
error 3799). If I put this field back into T1 and try to save, everything is
fine? This is a new database still in test mode so I deleted all info from
all tables (except those that are lookup tbls), but this did not work. Do
you have any suggestions?

 

[Allen Browne]

If you have not yet turned off Name AutoCorrect, you might try that.

Go to:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

 

[Guest]

That feature is turned off. Just to be clear, I actually deleted the field
from Tbl1 and added the same field name to Tbl2. I cannot make any changes to
Tbl1 and save without getting the error re field name not found? Any other
suggestions?

 

[Guest]

I found the problem. For the field in Tbl1 I had put a validation rule, I
thought by deleting the field it would have deleted the rule but it did not.
I clicked on properties of the deleted field in Tbl1 and found the VR.
Problem Solved. Thanks for the help.