Hi Baz,
thanks for your reply.
Let me be more specific:
We use a file server where we store our files.
I want to develop a database which indexes the files, assign keywords
to the files so that relating files will be displayed when searched.
Perhaps there are different opportunities to store the files: either
within the database itself (which would blow up the size of the
database, or to store the files on the server - through the database -
and just place a link with the corresponding information in the
database. I would prefer this option.
Would you be aware of any other - easier - already windows built-in
possibilities to achieve this?
Grateful for any hints.
Thanks,
Stephan
Baz schrieb:
> I don't understand what you mean by "a database to which users can upload
> files". You want to actually store the files in the database? Why?
[quoted text clipped - 32 lines]
> > Thank you very much!
> > Stephan
Baz - 18 Jan 2007 11:51 GMT
Well I assume you have a lot of files, otherwise you wouldn't need this
database. Given that, I certainly wouldn't store the files in the database.
I would basically have two tables in the database. One (let's call it
"documents") contains a unique (primary) key for the documents (some kind of
user-created code or short name), and the file path. I suppose you could
use the file path as the unique key, but they can be very long and unwieldy.
So, the "documents" table has these fields:
document_code
document_path
The other table (called, say, "keywords") would contain the keywords, and
would have these fields (which together constitute the primary key for the
table):
document_code
keyword
Table "documents" would be related to table "keywords" on, obviously, the
document_code field.
Unfortunately for you, finding and manipulating the file paths is going to
demand VBA programming within Access, so you are going to need to develop a
level of proficiency (or find someone who has it) in order to complete this
system.
> Hi Baz,
>
[quoted text clipped - 56 lines]
> > > Thank you very much!
> > > Stephan