We try to save, store and view pdf file in Access Form but the database is SQL Server. What are the best option for the SQL type, binary or image?
Novice
Windows 10 
Access 2019
We try to save, store and view pdf file in Access Form but the database is SQL Server. What are the best option for the SQL type, binary or image?
Competent Performer
Windows 10 Office 365
OPENROWSET (Transact-SQL) - SQL Server | Microsoft Learn
See Example D
VIP
Windows 8 Access 2016
In my opinion, the best way is to store pdf-files in some directory on some server, and in your BE (Access, SQL Server, or whatever one) you store the links to those pdf's.
Sql Server View and Access Linked table to that view are different
Posting Permissions
Reply With Quote