SQL String: trying to create OLE Object for Access Database

I am creating a form in ASP that references an Access Database.  The form is supposed to create an table with several fields including one OLE Object field that I will be storing images in.  However, I am continuely getting an error when I try to set the field type as OLE Object.  Any Suggestions:

CREATE TABLE TestTable ([ItemID] text(6) Primary Key, [Title] Text(80), [Photo] OLE Object, [Descrip] memo)

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.

/Includes/CatConnect.asp, line 9
LVL 1
BPatrochAsked:
Who is Participating?
 
funkeConnect With a Mentor Commented:
CREATE TABLE TestTable ([ItemID] text(6) Primary Key, [Title] Text(80), [Photo] OLEObject, [Descrip]
memo)


take the space out of OLE Object - see above
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.