Thank you in advance, I am having trouble with renaming tables. I've tried every syntax I can get my hands on. Here is the code, is the statement wrong?
if form_in_new_name <> 0 then
sSQL = "ALTER TABLE " & form_in_name & "_table RENAME TO " & form_in_new_name & "_table ;"
Set rs2 = cn.Execute(sSQL)
Set rs2 = Nothing
My second question is, is there a way through an SQL statement to change a field type, either from one type to another, or simply the size such as, varchar(50) to varchar(100). If so what would the statement(s) be?