And if it isn't an enormously huge table you could do: CREATE TABLE <NEW_NAME> AS SELECT * FROM <OLD_NAME>; DROP TABLE <OLD_NAME>;
Just remember that you'd have to compact & repair the DB after this sometime soon to remove the garbage left over from the drop statement. Paul On Fri, 10 Jan 2003, Brad Smith wrote: > Thank you, Simon. I was just investigating that option as I received your > response. > > Brad Smith > > On 10 Jan 2003 at 16:14, Simon Oliver wrote: > > > 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 > > > > > > > >
