Database vs. shared drive

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amdi - 19 Jan 2006 18:11 GMT

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

Reply to this Message

Jonathan West - 19 Jan 2006 18:34 GMT

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.

Signature

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

> Hi
>
[quoted text clipped - 12 lines]
> Thanks in advance
> Jan Amdi

Reply to this Message

janine_docsonline - 20 Jan 2006 08:27 GMT

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

> Hi
>
[quoted text clipped - 12 lines]
> Thanks in advance
> Jan Amdi

Reply to this Message