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?
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?
OPENROWSET (Transact-SQL) - SQL Server | Microsoft Learn
See Example D
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.