Re: Documents in Database

Hey there,

this seems like a good idea, but is there a simple way to search the
documents this way. E.g. someone wants to
view all the files that have some product in the text. Can this be done from
within VB.net in the way of working
you are suggesting?

Thanks for the advice in advance!!

Regards,

Q

"RSH" <way_beyond_oops@xxxxxxxxx> schreef in bericht
news:O7Owv7pnFHA.2180@xxxxxxxxxxxxxxxxxxxxxxx
> You can still use the filesystem to store documents and simply store the
> documents metadata in the database. So all of your security etc can be
> managed as you would like, but you have the benefits of storing the docs
in
> the filesystem...this is how most document management systems do it. You
> can even secure the directory so it is in accesible to anyone without the
> appropriate permissions. this way you dont have to worry about the
problems
> you are encountering.
>
> Simply store a pointer to the file opposed to storing the file itself in
the
> database.
>
>
> "Q" <Q@xxxxxxxxx> wrote in message
> news:uDBaM7nnFHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
> > Hello you all,
> >
> > I want to store all kind of files (pdf, doc, xls, txt) in a database.
This
> > is no problem.
> >
> > The real problem is opening the files from within a .Net application.
> > I tried several ways to do it:
> > 1. Creating an object of e.g. word to open a document.
> > 2. Taking care of the problem through processes. --> create a process
and
> > run an instance of word...
> >
> > Both these solutions have the same problems. If word is already open
when
> > you create the object (or the process) and you close
> > it afterwards, the documents that were already open are closed also (and
> > changes are lost)
> >
> > Is there another way of handling files in .Net.
> >
> > Regards,
> >
> > Q
> >
>
>


.

Relevant Pages

  • Re: Best Method Of Storing Up To Date Website Imgaes
    ... Storing images in a database will normally result in a bloated database that ... have a sample database on my website that you can view (or import any part ... to lots of images rather than store the image its self. ...
    (microsoft.public.access.forms)
  • Re: Article Storage: Files vs. Database
    ... anyway to store other data thna just the description for each article ... approaches are to either store the articles in aspx files, ... indexed by the database, or to store the article text in the database. ... Some advantages of storing them in files are simplicity, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Article Storage: Files vs. Database
    ... store other data thna just the description for each article (price, ... approaches are to either store the articles in aspx files, ... indexed by the database, or to store the article text in the database. ... Some advantages of storing them in files are simplicity, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Space Required to store a file in database
    ... Unless you have/use your own compression routine, storing a file in a binary ... format ... I had a query on sql database, we know we usually store files of ... related to the amount of space required to store the files in the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)