Rename An Access 2007 Table

I can't rename an Access table from the Navigation Pane. When I right-click, the edit window opens for about 2 seconds showing the table name with a highlighted background and the rest of the little window is white indicating that I can now type in a new name.

When I take my hand off the mouse, however, to enter in the new name, the table name window turns solid again and the mouse cursor has jumped to a different table.

If I go to another machine in my area that has Access 2003 on it, I can use the right click popup menu to do table renames without any issue.

This happens across the board with all Access databases (of the 2007 variety).

It isn't a real show stopper as I can programmatically alter the table name with DoCmd.Rename NewTableName, acTable, OldTableName - but it is something of a curiousity factor.

I have swapped out the mouse...same thing happened.

I moved my mouse to the machine with Access 2003 on it, and had no problems do table renames.

Has anyone encountered this before?

Hello Hack. I am unable to reproduce the issue. Instead of using the mouse to double click to rename, Select the table name and press F2. Does it still give you the problem?

Sid

Yes...F2 works the same way.

It is very odd....no one else in my department can replicate the error either so something funky is going on with my machine (company laptop).

Have you tried Office Repair?

Sid

I don't have anything called "Office Repair"

I do have something called "Office Diagnostics" - is that the same thing?

When you insert the Office CD, It will ask you whether you want to "Remove" or "Re-install" or "Repair" MS Office. Choose "Repair".

We don't have CDs of anything.

All software upgrades, and new installs, are pushed to us across the network from our internal IT department.

In that case I guess, you might have to go in for a fresh install...

One quick question. Can you rename any file using "F2" or by right click on the desktop?

Quote:

---

Originally Posted by koolsid

One quick question. Can you rename any file using "F2" or by right click on the desktop?

---

Yes...

And a fresh in install is out of the question. That is not something I have the ability to do and IT won't do it for something as insignificant as this.

I wrote VBA code that will do table renames for me, so it isn't like I'm dead in the water.

Incidentially, I have Office 2007 at home as well, and have no issues with this function. It is something funk-a-delic with my company laptop.