Acess for a document database?

[CBK]

I want to create a document database, a library of documents. In the end,
I'd like to be able to search the database for a specific document or words
in a specific document through a form. Is access capable of that, or should
I look for software that stores documents?

 

[Steve]

Access is excellent for this application!!

IMPORTANT - store the documents in a separte folder; not in the database. In
the database will cause rapid bloat of the database file size.

You need tables that look like:
TblAuthor
Authorid
FirstName
LastName
etc

TblDocument
DocumentID
DocumentTitle
CreationDate
AuthorID
etc

TblDocumentWord
DocumentWordID
DocumentID
DocumentWord

Steve
(e-mail address removed)

 

[Fred]

We do this. The database part is pretty easy, but there are numerous
related practical/ administrative decisions that typically need to be made
with these.

1. Unique identifying number for the document?
2. Will you have Access assign the number (e.g. autonumber) (which means
you'll the DB to take out a number. Or a system which lets anybody take
out a number without checking anywhere with little or no chance of
duplicaiton. For example, a document number taken out could get a number
for the year, date and time...e.g. 10.01 AM this today would be
2009-0518-1000
3. What if you have multiple copies or formats stored.



Having both paper and electronic documents