ALTER (or CREATE) TABLE/Ole Object Data Type

[JohnJohn]

Hello. I need to be able to create a column in an Access table that has the
"Ole Object" data type, but I need to be able to do it using SQL syntax
(ALTER TABLE or CREATE TABLE). For the life of me, I can't find any
information on how or if this can be done, which means to me that it probably
can't be done this way. My database is an Access 2003 database, and the SQL
Syntax to create this column is called from a Visual Basic 6 application
using the ADO 2.8 library.

Any ideas? Need any more info?

Thanks,
John

[John Mishefske]

Post by JohnJohn
Hello. I need to be able to create a column in an Access table that has the
"Ole Object" data type, but I need to be able to do it using SQL syntax
(ALTER TABLE or CREATE TABLE). For the life of me, I can't find any
information on how or if this can be done, which means to me that it probably
can't be done this way. My database is an Access 2003 database, and the SQL
Syntax to create this column is called from a Visual Basic 6 application
using the ADO 2.8 library.

My ADO 2.7 help file says the IMAGE data type does this:

"IMAGE Size: As required. Zero to a maximum of 2.14 gigabytes. Used for OLE objects."

I can't offer any tips as I haven't used this but thought this may help you find a solution.

[JohnJohn]

Thanks John. Hmm...I didn't see an image data type available in Access. Nor
did I see an adImage data type constant in ADO. I wonder if they're giving
SQL Server-specific info.

Thanks,
John

Post by John Mishefske

Post by JohnJohn
Hello. I need to be able to create a column in an Access table that has the
"Ole Object" data type, but I need to be able to do it using SQL syntax
(ALTER TABLE or CREATE TABLE). For the life of me, I can't find any
information on how or if this can be done, which means to me that it probably
can't be done this way. My database is an Access 2003 database, and the SQL
Syntax to create this column is called from a Visual Basic 6 application
using the ADO 2.8 library.

"IMAGE Size: As required. Zero to a maximum of 2.14 gigabytes. Used for OLE objects."
I can't offer any tips as I haven't used this but thought this may help you find a solution.
--
'---------------
'John Mishefske
'---------------

[Paul Clement]

On Tue, 1 Aug 2006 14:26:01 -0700, JohnJohn <***@discussions.microsoft.com> wrote:

¤ Hello. I need to be able to create a column in an Access table that has the
¤ "Ole Object" data type, but I need to be able to do it using SQL syntax
¤ (ALTER TABLE or CREATE TABLE). For the life of me, I can't find any
¤ information on how or if this can be done, which means to me that it probably
¤ can't be done this way. My database is an Access 2003 database, and the SQL
¤ Syntax to create this column is called from a Visual Basic 6 application
¤ using the ADO 2.8 library.
¤

The Jet DDL synonyms for this data type are:

IMAGE
LONGBINARY
GENERAL
OLEOBJECT

ALTER TABLE tblCustomers
ADD COLUMN MyOleObjectColumn OLEOBJECT


Paul
~~~~
Microsoft MVP (Visual Basic)