Hi,
I have used this before but for some reason it is not working here. I used this with MS Access 2003 and maybe that has something to do with it, I do nto know; I am using 2007 here. However, I tring to change a text field to a number(double). It does not error or anything but it does not change it either.
The code I am using is :
Any ideas would be really appreciated.Code:strSql = "ALTER TABLE [TempAging] ALTER COLUMN [ORDRNBRS] Number(Double)" cn.Execute strSql
Thank you
itm