"ina" <roberta.inalbon@gmail.com> wrote in message
news:1172130561.427831.290640@k78g2000cwa.googlegroups.com...
> Hello Guys,
>
> I would like to store big file in database? (between 3 to100 pages
> with pictures)
>
> What do you advice to do? storing the information in ntext field? or a
> link to this file?
>
> I would like to generate report querying this table and have all the
> information in a whole and unique file (e.g. *.doc)
>
> Any suggestion will be very appreciate
>
> Ina
>

"Stefan Delmarco" <StefanDeOnline@fotia.co.uk> wrote in message
news:eLJxHJmVHHA.488@TK2MSFTNGP06.phx.gbl...
> If you still want to store your files in the database, use an IMAGE (SQL
> 2000) or VARBINARY(MAX) (SQL 2005) field. Using these data types will also
> allow you to leverage SQL's full text search for these files.
>
> --
> Cheers,
> Stefan Delmarco
>
> http://www.fotia.co.uk
>
>
>

On Feb 22, 10:47 am, "vt" <vinu.t.1...@gmail.com> wrote:
> Ina,
>
> I recon you should store the file separately in system and just put the
> location I table. If you store picture in db, performance will be very poor.
> I absolutely agree with Uri's comment
>
> VT
>
> "Stefan Delmarco" <StefanDeOnl...@fotia.co.uk> wrote in message
>
> news:eLJxHJmVHHA.488@TK2MSFTNGP06.phx.gbl...
>
>
>
> > If you still want to store your files in the database, use an IMAGE (SQL
> > 2000) or VARBINARY(MAX) (SQL 2005) field. Using these data types will also
> > allow you to leverage SQL's full text search for these files.
>
> > --
> > Cheers,
> > Stefan Delmarco
>
> >http://www.fotia.co.uk- Hide quoted text -
>
> - Show quoted text -

"ina" wrote:

> On Feb 22, 10:47 am, "vt" <vinu.t.1...@gmail.com> wrote:
> > Ina,
> >
> > I recon you should store the file separately in system and just put the
> > location I table. If you store picture in db, performance will be very poor.
> > I absolutely agree with Uri's comment
> >
> > VT
> >
> > "Stefan Delmarco" <StefanDeOnl...@fotia.co.uk> wrote in message
> >
> > news:eLJxHJmVHHA.488@TK2MSFTNGP06.phx.gbl...
> >
> >
> >
> > > If you still want to store your files in the database, use an IMAGE (SQL
> > > 2000) or VARBINARY(MAX) (SQL 2005) field. Using these data types will also
> > > allow you to leverage SQL's full text search for these files.
> >
> > > --
> > > Cheers,
> > > Stefan Delmarco
> >
> > >http://www.fotia.co.uk- Hide quoted text -
> >
> > - Show quoted text -
>
> Thank you very much for this information. :D :D I was thinking about
> to store all in DB as I would like to be able to produce rapport in
> access project .adp. But definitely build a file system it is much
> more easy and trustful
>
> ina
>