A
AngelShadow
Hi! I'm fairly new to Access (I'm on my seventh database) so forgive a
fairly basic design question.
I'm designing a database that will be responsible for tracking about 200
documents submitted from teachers around the world. Most of them are one or
two page word documents. Some are small excel or publisher files. We have
the occasional .pdf or website. The documents will have a lot of "stuff"
that needs to be tracked related to each one:
-copyright checks
-initial review (resulting in a new word doc ),
-some will need reviews from a group of internal or external experts (they
will have "review forms" (new doc)- each review form having feedback about
the document and revisions to the document. we'll get about 4 filled out
review forms for each document)
-revised document (that will eventually go live on a resources webpage)
-some versions will need to be converted from their original formats-
resulting in .pdf docs that should stay with the original
-some will need instruction sheets
Needless to say, this is a helluva lot of documents to keep track of. What
do I do with them all? I've been eyeing the "Attachments" field longingly but
fear to begin using it due to database bloat. I've seen postings that say
don't use it for photos, but no comments about how much space the word
documents would use. Can anyone tell me if i can get away with it? How many
Word docs before I fill up my 2 GB?
Are there any other useful ways of tracking lots of documents without
requiring the user to update the location of the document each time they move
it?
THANK YOU!!
~Becca
fairly basic design question.
I'm designing a database that will be responsible for tracking about 200
documents submitted from teachers around the world. Most of them are one or
two page word documents. Some are small excel or publisher files. We have
the occasional .pdf or website. The documents will have a lot of "stuff"
that needs to be tracked related to each one:
-copyright checks
-initial review (resulting in a new word doc ),
-some will need reviews from a group of internal or external experts (they
will have "review forms" (new doc)- each review form having feedback about
the document and revisions to the document. we'll get about 4 filled out
review forms for each document)
-revised document (that will eventually go live on a resources webpage)
-some versions will need to be converted from their original formats-
resulting in .pdf docs that should stay with the original
-some will need instruction sheets
Needless to say, this is a helluva lot of documents to keep track of. What
do I do with them all? I've been eyeing the "Attachments" field longingly but
fear to begin using it due to database bloat. I've seen postings that say
don't use it for photos, but no comments about how much space the word
documents would use. Can anyone tell me if i can get away with it? How many
Word docs before I fill up my 2 GB?
Are there any other useful ways of tracking lots of documents without
requiring the user to update the location of the document each time they move
it?
THANK YOU!!
~Becca