Upload file to Access database via form

Hi all,

I am new to access and I face the following "issue":
I would like to create a database, to which users can upload files
(=pdf, doc, xls...). The files shall be stored locally on a server.
The database needs to be accessed via Access form (no html, asp,...) as

we don't have an internal web server running.
I would like to create a form that allows the user to browse his local
harddrive, select the file and upload it directly either to the
database or any other place on the server (which would be predefined by

the database admin).
Searching, browsing and retrieving of the files uploaded would complete

this nice database.

I use MS Access 2003 (and all of the users likewise).

Could anyone of you please share some insights with me on how to cope
with that?

Responses are greatly appreciated.

Thank you very much!
Stephan

re: Upload file to Access database via form

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?
Anyway, your next statement seems to contradict this: "The files shall be
stored locally on a server."

You already have an effective mechanism for "Searching, browsing and
retrieving of the files", it's Windows!

All in all, not at all clear what you want to do and why.

"Stephan" <fred_feuer_stein2001@yahoo.dewrote in message
news:1169115213.662954.100590@m58g2000cwm.googlegr oups.com...

re: Upload file to Access database via form

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:

re: Upload file to Access database via form

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.


"Stephan" <fred_feuer_stein2001@yahoo.dewrote in message
news:1169118730.612567.39300@11g2000cwr.googlegrou ps.com...uploadbeasbycomplete