SQL data types in CREATE/ALTER TABLE queries 1

[combo]

I found a list a list of Access SQL data types from MS here.
However, this article refers to Access 2013. In the meantime Access introduced large number and extended datetime fields handling. Is it possible to generate new types fields with access query, if so - what type names should be used?

 

[strongm]

Maybe this will help a bit

Microsoft Access Data Types - Open Database Connectivity (ODBC)

Microsoft Access Data Types

learn.microsoft.com

 

[combo]

Thanks, it seems that there is a total mess here. I tested some types, my observations:

• Access will not save query with not recognized field type,
• a direct answer to my post: simple BIGINT and DATETIME2 work!
• TINYINT is not recognized, BYTE works,
• TEXT and LONGTEXT create text and long text fields,
• some types have multiple keywords, as INTEGER and LONG for long.