Results 1 to 2 of 2
  1. #1
    EuniceH is offline Novice
    Windows Vista Access 2000
    Join Date
    Oct 2011
    Posts
    11

    varbinary(max) column in SQL Server is a Binary in the linked Access table

    The column in question is a varbinary(max) in SQL Server 2008 R2 Express, migrated over from the original MS Access 2000 database. When I do an ODBC link from SQL Server tables to MS Access 2000, the linked table shows that the column is a binary (with 512 length) in the MS Access design view. I want it to be an OLE Object, so that it shows on reports as a signature. This is what it does in a similar database setup, and shows on reports as a signature, so I can't figure out what I did different.

  2. #2
    EuniceH is offline Novice
    Windows Vista Access 2000
    Join Date
    Oct 2011
    Posts
    11
    when I link my tables on a computer that has Access 2000 SP3, I have no problem, the Access linked table shows it as an OLE Object, and the report shows the signature.
    When I link my tables on a computer that has Access 2000 SP1, that's my problem, so I'll just have to upgrade.
    Thanks for viewing.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  2. Replies: 3
    Last Post: 01-03-2012, 12:28 PM
  3. Replies: 1
    Last Post: 01-22-2011, 12:23 PM
  4. Linked SQL Server Table Problems
    By jalton in forum Import/Export Data
    Replies: 3
    Last Post: 02-13-2010, 12:52 AM
  5. Linked Table To SQL Server?
    By snkscore in forum Import/Export Data
    Replies: 3
    Last Post: 12-09-2009, 06:36 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums