Rename a Table in Access 2003?

Posted on 2007-08-02
Last Modified: 2008-05-16
How can I rename a table in Access 2003?
Question by:Errol Farro
    1 Comment
    LVL 58

    Accepted Solution

    A local table? That is simple:

        CurrentDb.TableDefs("tblOldName").Name = "tblNewName"

    I'm assuming you meant "from code". Else, just select it and use [F2], naturally.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Read about achieving the basic levels of HRIS security in the workplace.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now