Can not delete field?

[Jason]

I am trying to delete two fields in a table. When I
delete the two fields and try to save the table, I get the
following error: Could not find field "XXXX". What is
causing this and how do I get around it?

 

[Pieter Wijnen]

probably db corruption

Pieter

 

[Joan Wild]

I am trying to delete two fields in a table. When I
delete the two fields and try to save the table, I get the
following error: Could not find field "XXXX". What is
causing this and how do I get around it?

You may have a table level validation rule that refers to one of your
deleted fields. Or perhaps the table sort order is set to one of these
fields. You can check for these in the properties dialog for the table

 

[Pieter Wijnen]

it might also have to do with autocorrection as described on allenbrowne.com
tools->options-> general, track name autocorrect info
--
Pieter Wijnen

When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca
http://allenbrowne.com/

 

[Guest]

Also make sure that those fields are not foreign keys to other tables

Hope this helped.