Rename An Access 2007 Table

[Hack]

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?

[Siddharth Rout]

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

[Hack]

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).

[Siddharth Rout]

Have you tried Office Repair?

Sid

[Hack]

I don't have anything called "Office Repair"

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

[Siddharth Rout]

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

[Hack]

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.

[Siddharth Rout]

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?

[Hack]

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.