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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top