Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2007

Tip: Looking for answers? Try searching our database.

Upload file to Access database via form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stephan - 18 Jan 2007 10:13 GMT
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
Baz - 18 Jan 2007 11:06 GMT
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.

> Hi all,
>
[quoted text clipped - 22 lines]
> Thank you very much!
> Stephan
Stephan - 18 Jan 2007 11:12 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.