storing and retrieving pdf documents in Access using vb.net

[kum121]

Hello friends,

 

I am a newbie to the .net platform. I am doing a small work at my office which needs to store pdf files into access database.

 

I have declared the datatype as OLE object

 

and I tried to read and save the pdf file as byte array

 

and i recieve type mismatch error.

 

anyone plz help me.

 

thanks in advance.

 

kumar

[donnacha]

I would not recommend storing the pdf object in Access, you are guarnteed to run into problems later. You are much better off storing a link or path to the pdf file in the database and then load the pdf from that location.

[Derek Stone]

I'm going to have to agree with donnacha on this one. If you were using Microsoft SQL Server or any other decent RDBMS, storing the files in the database itself wouldn't be too much of an issue. Microsoft Access databases however, tend not to bode well with these types of things.