Access 2003 database in 2007, Rename not working

[Clarie]

DoCmd.Rename on a linked table does not rename the table. It does not raise
any errors either. This happens with Access 2007 runtime only. It works as
expected with Access Retail.

Is there a workaround for this issue?

Thanks

 

[Douglas J. Steele]

The appropriate way to rename a table is:

CurrentDb().TableDefs("OldName").Name = "NewName"

 

[Clarie]

Thanks. I'll give that a try.

The appropriate way to rename a table is:

CurrentDb().TableDefs("OldName").Name = "NewName"