Solved I Can't ALTAT tinyint

[ADIGA88]

Hi Guys,

I am trying to change a field type using the DoCmd.RunSQL I succeed with other types but I can't change to tinyint datatype (error message attached)

 DoCmd.RunSQL "ALTER TABLE tblNotification ALTER COLUMN NotificationDate tinyint;"

 

[The_Doc_Man]

Change it to some other size first to see if the problem is tinyint or something else. What is the current (i.e. before alteration) data type?

 

[arnelgp]

DoCmd.RunSQL "ALTER TABLE tblNotification ALTER COLUMN NotificationDate Integer;"

 

[sonic8]

I can't change to tinyint datatype

Access doesn't know the type TinyInt; use Byte instead.

 

[ADIGA88]

Byte Indeed,

It worked with the Byte Keyword and changed to (Number > Byte) in the table design view.

FYI, the datatype was INTEGER

 

[The_Doc_Man]

I should have realized the error. TinyInt is an SQL datatype on some SQL servers but not for native Access. I mistakenly assumed you were on an SQL Server situation from that syntax.