Strange error from table design (1 Viewer)

Hello,

I've just started to rework a database (the original creator is not available). I am trying to rename one of the fields ("oldfieldname" to "newfieldname"), but when I try to save it I get an error message saying "Could not find field oldfieldname".

Clicking on "help" gives me:
Could not find field <name>. (Error 3799)
A column name that does not exist is being referenced.

I can't find anything that would be trying to reference this field!

Anyone ever experience this?

Thanks in advance,
-Sean

Sean,

I've only seen one reference to this problem, and a Compact/
Repair fixed it up.

Wayne

Hi Wayne,

you were right on the money! Not only did compacting it work, but it also automatically changed those fields to what I was trying to rename them to.

The sad thing is, this isn't the first time that a simple "compact & repair" fixed my problem - I need to remember to do that more often!

Thanks Wayne!

-Sean