I'm pretty deep into a web application I'm building for my current employer. It's about 90% done, 3 weeks of work. Because of this I do not want to change the setup of the project.
I would ideally like to be able to change the size of fields in a table. Such as, varchar(50) to varchar(100). I'm just wondering if the resizing is possible.
Another problem I am having is renaming a table. I've seen the syntax for it but everytime I try it doesn't work.
if not form_in_new_name = "" then
sSQL = "RENAME " & form_in_name & "_table TO " & form_in_new_name & "_table ;"
Set rs2 = cn.Execute(sSQL)
Set rs2 = Nothing
Thanks for the help in advance!