Could not find field

J

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?
 
L

Lynn Trapp

Jason,
I've never seen anything like that with a table, but did once encounter a
form that couldn't be deleted. It suggested to me then, as does your
situation, that there was an underlying corruption involved. You might try
doing a Make Table query, using your original table as the base, and
selecting all the fields except for the 2 that you want left out. Then you
can delete the original table and rename the new one to the name of the
original.
 
Top