Interesting approach, one I think I will try, because OLE syntax confuses me still. But, if you are recommending that the db would need to be recompressed "sometime soon", could I automate the recompression via the OLE, following performing a "copy" and "drop" via the DBI module? At which point, I guess I will still need to muddle through the OLE perldoc.
Thanks, y'all for the advice. Brad Smith On 10 Jan 2003 at 11:27, Paul Boutros wrote: > 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 > > > > > > > > > > > > > > >
