Re: Documents in Database

Hey Phill,

I our office, we have to deal with lots of documents that have to be
distributed among different users.
I would like to store all my files in a database so I can check who read the
files and who didn't.
I also want to give some users the possibility to read some files, while
other users can't read them.
It would be some kind of distribution center of documents....

Regards,

Q



"Phill. W" <P.A.Ward@xxxxxxxxxxxxxxxxxxx> wrote in message
news:ddfp68$sli$1@xxxxxxxxxxxxxxxxxxxx
> "Q" <Q@xxxxxxxxx> wrote in message
> news:uDBaM7nnFHA.3568@xxxxxxxxxxxxxxxxxxxxxxx
>> I want to store all kind of files (pdf, doc, xls, txt) in a database.
>> This is no problem.
>
> I find it is often /easier/ to work with such files when they are safely
> out in the file system!
>
>> 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...
>
> 3. Get the file out of the database, into the file system, and use
> Process.Start to launch the document /itself/, thereby invoking the user's
> default application for that type of document.
>
>> 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)
>
> Your problem is not in opening the document, but in knowing just
> /when/ the user has finished mucking about with it.
> Is your application waiting for the Start'ed (editor) process to end?
> That would /help/, although it might be waiting a very long time before
> the user closed down something like Word.
>
> Take a step back from the technical nitty-gritty for a moment
> - What is it you're hoping to achieve with this?
>
> Regards,
> Phill W.
>
>


.

Relevant Pages

  • Re: Choosing the right embedded database.
    ... We want a simple database ... > Most users would download the application and data from a website via DIAL ... > access is the only real method of distribution, ... > local data store via an internet link. ...
    (borland.public.delphi.thirdpartytools.general)
  • Choosing the right embedded database.
    ... I am looking for the right tool for the job and came across you database ... Most users would download the application and data from a website via DIAL ... access is the only real method of distribution, ... local data store via an internet link. ...
    (borland.public.delphi.thirdpartytools.general)
  • 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)
  • Re: cant mount information store
    ... I then reinstalled exchange and then installed exchange 2003 ... Information Store First Storage Group: Database recovery failed ... Microsoft Exchange Information Store. ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... 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)