Can't change field name in table

kicrewd

Registered User.
Local time
Today, 05:24
Joined
Sep 3, 2014
Messages
18
I am trying to change the name of a field in a table. When I hit save, it gives me the error:

"Could not find field 'originalFieldName'"

I hit OK and it says:

"Errors were encountered during the save operation. Properties were not updated."

There are no queries, forms, reports, or relationships shown on the relationships tab. The other fields in the table have drop-down menus of values stored in other tables, but not this field. It just has values I entered in it manually.

Why can't I change the name of the field? I have Access 2007.
 
perhaps your 'originalFieldName' is a reserved word?

Failing that, try compacting the db

Alternatively create a new field with the 'right' field name, run an update query to copy the values from the 'originalFieldName' then delete the 'originalFieldName'
 

Users who are viewing this thread

Back
Top Bottom