VarBinary (1 Viewer)

[zezo2021]

Hello

I Store PDF in Var Binary field in SQL server Db

How can I compact this field to a minimum size

Because the DB become bigger after uploading some PDF FIELD


Any tips or tricks

Thank you so much

 

[theDBguy]

One idea is to zip the file first before storing it. Why are you worried about the size of the db?

 

[zezo2021]

Online

 

[theDBguy]

Online

Shouldn't matter.

 

[zezo2021]

I have a limit for the DB 200 MB Only

 

[zezo2021]

I'm using GoDaddy

and access and SQL server

I can store the pdf in the web hosting folder

but I don't know how to get the path of the file from the Microsoft access

 

[theDBguy]

I'm using goddady

and access and SQL server

I can store the pdf on web hosting


but I don't know how to get the pass of the file from access

Maybe you can ask them if you have FTP capability. If so, you can use FTP to download the file from their server using Access.

 

[zezo2021]

up

 

[zezo2021]

Maybe you can ask them if you have FTP capability. If so, you can use FTP to download the file from their server using Access.

I want to store the Path of the file (Online) path inside string field

user click on this link or string open the file

 

[theDBguy]

I want to store the Path of the file (Online) path inside string field

user click on this link or string open the file

Yes, I understand. If it's just PDF, you might be able to use a URL (depending on how/where it's stored online), and the file will open in the browser. If you want the file to open using Acrobat Reader, you'll have to download the file first.

 

[OuterApply]

I liked dbguy suggestion about ftp as it made me think of other things too.
As just one (of many possible) random examples, check out Adrive.com
They offer very cheap plans and FULL ftp capability - totally open (not just sftp) which would allow you to store files and then write vba code to easily grab a copy of it for the user and open it when needed, or send files up as well.
Just another thought.