Database vs. shared drive

Hi

Iâ??m about to develop at system, where the user can create a standard
document, by choosing among hundreds of standard paragraphs (documents).
Right now, all the documents (Word) are placed on a shared drive, and only
the filename, path and description is stored in a database â?? and that
solution works fine.
But why not save all the documents in the database as well?

I donâ??t knowâ?¦. Do you?

I need some advice.
Will I gain anything by saving the document in a database?

Thanks in advance
Jan Amdi

Jonathan
Thu Jan 19 12:34:46 CST 2006

Hi Jan,

It depends on whether the documents contain formatting that needs to be
preserved when they are inserted. If so, then you are probably better off
with your existing arrangements, though you could also experiment with the
idea of putting these text samples into a single template in AutoText
entries, and storing the Autotext entry names in the database.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org


"Amdi" <Amdi@discussions.microsoft.com> wrote in message
news:5BB0C7D7-AAB7-4132-898F-794C967BDC6B@microsoft.com...
> Hi
>
> Iâ??m about to develop at system, where the user can create a standard
> document, by choosing among hundreds of standard paragraphs (documents).
> Right now, all the documents (Word) are placed on a shared drive, and only
> the filename, path and description is stored in a database â?? and that
> solution works fine.
> But why not save all the documents in the database as well?
>
> I donâ??t knowâ?¦. Do you?
>
> I need some advice.
> Will I gain anything by saving the document in a database?
>
> Thanks in advance
> Jan Amdi
>

janine_docsonline
Fri Jan 20 02:27:02 CST 2006

You might try looking at Content Library and add-in utility utilising Access
Database. You can do it either way with file names or with content, being
formatted text. There is also AutoDoc which uses paragraphs and autotext to
build documents.

Have a look at www.cdev.co.uk to learn more. CDEV Computing. Both great
utilities. I have a desription of Content Library on my web site
www.docsonline.net.au also if that helps.

Regards
Janine




"Amdi" <Amdi@discussions.microsoft.com> wrote in message
news:5BB0C7D7-AAB7-4132-898F-794C967BDC6B@microsoft.com...
> Hi
>
> I'm about to develop at system, where the user can create a standard
> document, by choosing among hundreds of standard paragraphs (documents).
> Right now, all the documents (Word) are placed on a shared drive, and only
> the filename, path and description is stored in a database - and that
> solution works fine.
> But why not save all the documents in the database as well?
>
> I don't know.. Do you?
>
> I need some advice.
> Will I gain anything by saving the document in a database?
>
> Thanks in advance
> Jan Amdi
>