If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Acess for a document database?
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? -- Carolyn |
#2
|
|||
|
|||
Acess for a document database?
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 "CBK" wrote in message ... 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? -- Carolyn |
#3
|
|||
|
|||
Acess for a document database?
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 |
Thread Tools | |
Display Modes | |
|
|