How to Rename a table fieldname from code ?

[6kleg]

Can anyone tell me what is the correct methods or actions to use to permanently change the name of a table field from code?

 

[Sindo]

Hi 6kleg,

I use the "Microsoft ADO extension for DDL and security" in a VB app to add/remove/rename fields and tables in code when I release a new version of our application.

Do a search in google for ADOX and you should find some example code - I'd include mine but it'd be huge and I'd have to comment it

Heres a link that discusses it and has links to downloads etc.

http://www.4guysfromrolla.com/webtech/013101-1.shtml

Hope this helps

Sindo