Trying to get an Alter table to work

[itm]

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 :

strSql = "ALTER TABLE [TempAging] ALTER COLUMN [ORDRNBRS] Number(Double)"
    cn.Execute strSql

Any ideas would be really appreciated.
Thank you
itm

[orange]

Try the following.

strSql = "ALTER TABLE [TempAging] ALTER COLUMN [ORDRNBRS] Double"

You may have to delete the original text values (unsure, untested)

[itm]

Well thank you, but unfortunately that did not work.

[orange]

Did not work is not too helpful -- did you get an error?

I tried a query on one of my tables.
The Agency table had a field newfld that was Text.


This works for me in Acc2003

Sub testalter()

Dim sql As String
sql = "Alter table agency alter column newfld double;"
CurrentDb.Execute sql
End Sub

[itm]

Well as I said before I do not get any errors, it jsut does not work; but I think it is something to do with 2007, because it did work for mee too when I used to use 2003. That is oky I fugured out a work around. Thanks for trying.

[orange]

Well this is a forum for everyone to learn, so why not tell the current and future readers what you did for a work around.
The info at the top of your post indicates you have 2003.