Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft SQL Server _ Blob Question

Posted by: ordnance1 Oct 23 2019, 06:32 PM

I have an SQL server backend to my ms access front end. I have code that allows me to store photos to the SQL server as BLOBs. I also would like to also add PDF's. They are mostly small in sizer but when I add pdf to the list of formats access gives me an error message. Is it not possible to to store PDF's this way?

CODE
.Filters.Clear
    .Filters.Add "Images", "*.jpg; *.jpeg; *.tiff; *.gif; *.bmp; *.png; *.pdf; *.ico"



Posted by: June7 Oct 23 2019, 06:50 PM

For saving pdf to SQLServer db review

https://stackoverflow.com/questions/55485748/insert-pdf-file-into-SQL-server-linked-database

https://www.sqlservercentral.com/forums/topic/saving-pdf-or-word-document-to-SQL-server-database