RE: ODBC/OLEDB failure accessing MS Access "Attachment" field in query

Joe has made more progress than I have so far, trying to link a data type =
Attachment field via ODBC. In my case, I'm using a different ODBC driver
(and MySQL Connector / ODBC 3.51 ) host database (MySQL on Linux).

Joe (or anyone else), how in the first place were you even able to set up a
linked table with a field data type = Attachment?

Depending on what SQL datatype I define for this field, when I import
that field (link) into the Access table, the Access data type is
either Binary or OLE Object. Access won't allow me to change its data
type to Attachment, giving me the error message: "You cannot set 'This
Field' to the Attachment data type. You can only set a column to the
Attachment data type when that column is first created."

Cheers
-- Mark

.

Relevant Pages

  • Re: Data Type Question
    ... Those could be user-defined data type. ... "Joe Williams" wrote: ... > Thanks for the response. ... > as I have Micorosft SQL 2000 Server and one of my valid choices in ...
    (microsoft.public.sqlserver.programming)
  • Re: OracleDataAdapter.Fill not mapping Oracle data types to .NET data types
    ... > Hi Joe, ... >> data type of a column from Oracle, so I can test for a VARCHAR2 type ... not exactly - you shouldn't initcap all strings IMO. ... >>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/ ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: LPCTSTR: whats going wrong here?
    ... _T is a macro that takes an argument; it is not a data type, and cannot be used as you ... illustrate. ...
    (microsoft.public.vc.mfc)
  • Re: Date/Time question
    ... If the values are strings, use CDate, e. ... Dim varTime1 As Date ... > What data type for a variable would you use for say a variable like such: ...
    (microsoft.public.vb.com)
  • Re: access97 & .copyFromRecordset different when using sql server 2005
    ... the sql data type for this field is 'int' ... and yes I use ODBC to link to the table from within access ... and if I use the string syntax like '999', I get an error "Data type ... SELECT * FROM qryIPS WHERE location like '999' ...
    (comp.databases.ms-access)