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?