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 > > >
