Re: Renaming tables in Access

[Simon Oliver]

Brad Smith wrote:
> Is there a way to rename a table in and Access database?
>

AFAIK, there is no RENAME SQL command in the Microsoft Jet SQL reference, nor such a method in the DAO reference. However you can use OLE with the Microsoft Access Object Library and use the DoCmd.Rename method:

DoCmd.Rename "Old Employees Table", acTable, "Employees"

--
Simon Oliver