SQL String: trying to create OLE Object for Access Database
Posted on 2002-04-01
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