Error 3799 Field name not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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?
 
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.
 
Back
Top