I am running Access 2010/VBA Front End and SQL Server 2012 Back End. Can anyone point me to articles on how to save and retrieve documents (.pdf, .docx, ,.xlsx, etc.) from my application using SQL Server Filestream feature? Thanks, Eddie
I am running Access 2010/VBA Front End and SQL Server 2012 Back End. Can anyone point me to articles on how to save and retrieve documents (.pdf, .docx, ,.xlsx, etc.) from my application using SQL Server Filestream feature? Thanks, Eddie
Bing: Access vba SQL Server Filestream
Maybe this will help https://msdn.microsoft.com/en-us/library/bb933972.aspx
Sometimes VB code is adaptable to VBA.
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.
Okay, I found it. However, you must be using SQL Server 2012 or higher. See...
http://www.mssqltips.com/sqlserverti...l-server-2012/
Hope this helps someone else. Thanks, Eddie