Alter Table SQL

[JB]

Hi,

I am not sure if this is the specific group I should be posting too, but I
have a table with the field 'ModifiedDate'. This field is currently a
string, but I would like to convert it to a Date/Time field.

I have tried to execute the following SQL:
"ALTER TABLE tblClause MODIFY ModifiedDate Date/Time" and "ALTER TABLE
tblClause MODIFY ModifiedDate DateTime".

Both of the above statements give the following error:
"Syntax error in ALTER TABLE statement."

This is a standalone database, in Access 2000 file format. I am using
Access 2003 to open / modify it.

Any help would be much appreciated.

 

[David Lloyd]

I don't believe the "MODIFY" statement is supported. Try "ALTER COLUMN"
instead, with the "DateTime" data type.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi,

I am not sure if this is the specific group I should be posting too, but I
have a table with the field 'ModifiedDate'. This field is currently a
string, but I would like to convert it to a Date/Time field.

I have tried to execute the following SQL:
"ALTER TABLE tblClause MODIFY ModifiedDate Date/Time" and "ALTER TABLE
tblClause MODIFY ModifiedDate DateTime".

Both of the above statements give the following error:
"Syntax error in ALTER TABLE statement."

This is a standalone database, in Access 2000 file format. I am using
Access 2003 to open / modify it.

Any help would be much appreciated.

 

[JB]

David,

Thanks alot for the tip, that has worked perfect.