Re: Rename field in Access DB

2008-05-15 Thread Iain King
On May 14, 4:29 pm, Tim Golden <[EMAIL PROTECTED]> wrote: > Iain King wrote: > > I'm manipulating an MS Access db via ADODB with win32com.client. I > > want to rename a field within a table, but I don't know how to. I > > assume there is a line of SQL which will do it, but nothing I've tried > >

Re: Rename field in Access DB

2008-05-14 Thread Tim Golden
Iain King wrote: I'm manipulating an MS Access db via ADODB with win32com.client. I want to rename a field within a table, but I don't know how to. I assume there is a line of SQL which will do it, but nothing I've tried (from searching) has worked. Basic code: import win32com.client connectio

Re: Rename field in Access DB

2008-05-14 Thread Diez B. Roggisch
Iain King wrote: > I'm manipulating an MS Access db via ADODB with win32com.client. I > want to rename a field within a table, but I don't know how to. I > assume there is a line of SQL which will do it, but nothing I've tried > (from searching) has worked. > Basic code: > > import win32com.cli