Could not find field

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?

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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Jason" wrote in message
...
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?