How to specify blob type in MS Access?

Posted by Firat on Stack Overflow See other posts from Stack Overflow or by Firat
Published on 2010-06-08T23:14:55Z Indexed on 2010/06/08 23:22 UTC
Read the original article Hit count: 282

Filed under:

ms-access

|

blob

|

mdb

How to specify blob type in MS Access? I have office 2007 installed.

I am using jdbc, but this should not matter for the SQL query I am passing. Tried to pass a length to it, or FILE type, 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])
)

© Stack Overflow or respective owner

Related posts about ms-access

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

as seen on SQL Authority - Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and… >>> More
LINKED TABLES BETWEEN MS ACCESS 2003 AND MS ACCESS 2007-WRITE PERMISSIONS DENIED

as seen on Super User - Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files. In one case, the user has 2007 on his PC and opend the front end in 2007. No problems. When the the user is done, he clicks a button that executes a macro full of update queries. The macro… >>> More
Working with Compressed (zipped) folders in MS Access

as seen on Internet.com - Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application. >>> More
Extending the InputBox function for MS Access Forms

as seen on Internet.com - Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function. >>> More
Uses for Cartesian Products in MS Access

as seen on Internet.com - Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products. >>> More

Related posts about blob

Upload File to Windows Azure Blob in Chunks through ASP.NET MVC, JavaScript and HTML5

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/shaunxu/archive/2013/07/01/upload-file-to-windows-azure-blob-in-chunks-through-asp.net.aspxMany people are using Windows Azure Blob Storage to store their data in the cloud. Blob storage provides 99.9% availability with easy-to-use API through .NET SDK… >>> More
Can't create blob container on Azure Blob Storage

as seen on Stack Overflow - Search for 'Stack Overflow'
The following code throws an error on the "CreateIfNotExist" method call. I am attempting to connect to my Azure Blob storage and create a new container called "images" var storageAccount = new CloudStorageAccount( new StorageCredentialsAccountAndKey("my_account_name", "... my shared key ...")… >>> More
Display MySQL BLOB'd image on webpage without separate script (PHP)

as seen on Stack Overflow - Search for 'Stack Overflow'
So I've got some images stored in a MySQL database as BLOB's (I know it's better to just store the directory and do it that way, but this is what I need to do for now) and I need to display them on a webpage. Now, I know how to make a script and give it an image header and pull the img src from there… >>> More
JPA - insert and retrieve clob and blob types

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This article describes about the JPA feature for handling clob and blob data types.You will learn the following in this article. @Lob annotation Client code to insert and retrieve the clob/blob types End to End ADFaces application to retrieve the image from database table and display it in web page… >>> More
T-SQL Tuesday #006: Tiger/Line Spatial Data

as seen on SQL Blog - Search for 'SQL Blog'
This month’s T-SQL Tuesday post is about LOB data http://sqlblog.com/blogs/michael_coles/archive/2010/05/03/t-sql-tuesday-006-what-about-blob.aspx . For this one I decided to post a sample Tiger/Line SQL database I use all the time in live demos. For those who aren't familiar with it, Tiger/Line data… >>> More