How to specify BLOB type in MS Access?

Question

How to specify BLOB type in MS Access? I have Office 2007 installed.

I use jdbc, but it doesn’t matter for the SQL query that I am passing. I tried to skip the length or file type, it did not help.

CREATE TABLE mytable (
  [integer] INTEGER not null,
  [string] VARCHAR (255) ,
  [datetime] DATETIME ,
  [boolean] BIT ,
  [char] CHAR ,
  [short] SHORT ,
  [double] DOUBLE ,
  [float] FLOAT ,
  [long] LONG ,

  [blob] BLOB , // does not work

  Primary Key ([integer])
)

Answer 1

Use LONGBINARY as the data type for the blob field in your DDL statement. See Field Type Reference — Names and Values ​​for DDL, DAO, and ADOX