Access

Updated: 26 October 2023

This GitHub repo demonstrates the unexpected truncation of a Long Text (Memo) field to a Short Text field, when creating a new table with SELECT * INTO.

https://github.com/ChrisTaylorDeveloper/ms-access-unexpected-truncation

A good explanation here also http://allenbrowne.com/ser-63.html

Updated: 21 October 2023

CREATE TABLE tbl (
    bar LONG PRIMARY KEY, 
    foo VARCHAR(10) NOT NULL
);

Should fail because foo cannot be NULL

INSERT INTO tbl (bar) SELECT this FROM source;

Insert many rows

INSERT INTO tbl (bar, foo) SELECT what, ever FROM source;

Create a new table and add rows with a single statement

SELECT * INTO tbl_two FROM tbl;

Updated: 30 July 2023

• https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/sql-data-types
• https://learn.microsoft.com/en-us/sql/odbc/microsoft/microsoft-access-data-types?view=sql-server-ver16
• Data types for Access desktop databases