INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access Upload/Download Files (To FTP Server) That Pertain To Specific Records
2

Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

(OP)
Hello,
I have projects database that the users need to be able to upload & download types of files, like pdf's & jpg. I have made a database before that allowed you to upload/download files into the database, but that quickly 'bloats' (Makes the database huge) All my users have access to a common file server. How do I go about, via a form in Access, upload or download files pertaining to that specific record? I would want in their project form, a list of files that only pertain to that record & then they could simply click on the specific file to download it. I've having a hard time with figuring this out, but I know it's possible.

Thanks for any help!

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

Instead of having the file in the data base, can you have this file on the server and just keep the path (and the file name) in your data base?

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

(OP)
Hey Andy,
That's what I'm trying to do. Sorry if I didn't explain that very well. OK, let me explain further...I want them to be able to add a "file" to the database. When they select the file they want, it will place a link in the database for the file.

Project database.
They need to attach a word doc to the project.
I want them to be able to attach a file to the project.
I would prefer when they do this that it places that actual file on to a shared location (Some common folder)
Then, they can retrieve that file via the database form again. Never actually storing the file in the database.

That is what I'm ultimately trying to do. Especially since the users may delete the original file if they are attaching a linked file that is located on their computer instead of a shared location.

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

And the shared location is on a server only accessible via FTP?

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

(OP)
The location is actually mapped to a drive letter, so it doesn't have to use the FTP method.

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

So you simply need a routin to copy a selcted file from one place to another, and then simply store th epath of that copied file in your database.

You might like to look at the FileSystemObject, which has a Copy method. Or VBA's native FileCopy method.

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

"mapped to a drive letter" - be careful. Just because on your computer this server is an X:\ drive, on somebody else's machine it could be a Z:\ drive
I would use Universal Naming Convention (UNC) so the server would be something like:\\ntsvr6\ABCD\ on any computer.

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

(OP)
Thanks for your help guys, I will try to do what you offered. Yes, Andrzejek, I totally agree with your thoughts.

RE: Access Upload/Download Files (To FTP Server) That Pertain To Specific Records

(OP)
Hey strongm --- Do you happen to know a good resource (website) off the top of your head for finding some templates or examples of this routine you speak of? Thanks so much. I've searched some, but haven't found what I was looking for.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close