> > 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.
And you'd have to re-add constraints, etc. Simon's method is MUCH safer... Jeff > > 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 > > > > > > > > > > > > > > >
