Link to home
Start Free TrialLog in
Avatar of melinhomes
melinhomes

asked on

Attachment field in SQL

I had a list in SharePoint online with an attachment field.
Due to our environment (Citrix/Access) we are having issues.
I have a database, front end Access and back end is in SQL. I want to replace the SharePoint table (external data) with a SQL table, is it possible to keep the attachment field?
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of melinhomes
melinhomes

ASKER

Thanks for clearing that Jim, much appreciated.
Just to add a bit, there is code to pull the attachments back out if needed.

Then, you have two choices, which are the pre-attachment era way of handling things:

1. Store the object in a BLOB field in the database, extracting when needed to disk, working with it, then importing it back in.

2. Store the file path and name to the object, and link to it in some way (many use a Hyperlink).  This leaves the file on disk.

Jim.