Results 1 to 3 of 3
  1. #1
    jpg250 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    26

    Question Can a SQL Server varbinary(max) field be updated from Access front end

    Hi,
    I use Access 2013 and have a table with an 'Attachment' data type field. I found that using this data type increases the size of the database so much that it soon reaches it's maximum size.


    I'm now trying to use SQL Server 2012 Express as a back end to just store the attachments. In SQL Server I have specified the attachment field data type as 'varbinary(max)', but when I look at the linked table from Access, it shows as data type 'OLE Object'.
    My question is - is there any way I can write to or update this field using VBA, or would I be better off writing, say a WPF program, which allows the user to select the attachment and which then updates the SQL Server table (using C#), and somehow call this program from an Access Form.

    Is there is anyone out there who has tried this or something similar?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    For programmatically managing Access attachment field, review https://www.accessforums.net/program...ton-38798.html

    I have no idea if this can be applied to SQL Server table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jpg250 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    26
    Thanks June7. I'll update this post once I've got a working solution.

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

Similar Threads

  1. Replies: 14
    Last Post: 07-29-2013, 02:33 PM
  2. Updating SQL Server Views via MS Access front-end?
    By tzvi in forum Import/Export Data
    Replies: 1
    Last Post: 01-10-2013, 11:13 AM
  3. Using Access as Front End for SQL Server
    By workinstiff in forum Access
    Replies: 4
    Last Post: 07-18-2012, 12:16 PM
  4. Replies: 1
    Last Post: 04-23-2012, 03:41 PM
  5. Display varbinary in Access form
    By aspfun in forum Access
    Replies: 0
    Last Post: 06-29-2010, 02:06 PM

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