How do you rename a table?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

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
 
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"
 
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?
 
Something's definately not right - might be worth getting someone to have a
look at your machine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

renaming an object 1
Rename Multiple Tables at once 3
"Rename" function not working right 4
How do I rename a table in Acess 2007? 5
Reproducable bug with Access 2007 runtime: macro, rename table does notwork 8
Renaming control 2
how to rename a table using field name 1
Form won't work with renamed table... 1

Back
Top