How do you rename a table?

[Tony Williams]

I have Access 2007 and don't seem to be able to rename a table. In previous
versions I could right click and up pops a prompt and I keyed in a new name.
In Access 2007 when I right click there is a Rename choice but as soon as I
select it the prompt opens then closes immediately. How can I rename my table?
Thanks
Tony

 

[Rob Wills]

That should work.....

As a last resort you can always use the immediate window - but you shouldn't
have to do this

Currentdb.tabledefs("Old_Name").name = "New_Name"

 

[Tony Williams]

Thanks Rob. It's weird right clicking and trying to rename on any object
doesn't seem to work. As a work round I've copied the table and pasted it
with the new name then deleted the original. Wondered whether it was an
Access 2007 bug or my machine?

 

[Rob Wills]

Something's definately not right - might be worth getting someone to have a
look at your machine