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

[roystreet]

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!

 

[Andrzejek]

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.

 

[roystreet]

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.

 

[strongm]

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

 

[roystreet]

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

 

[strongm]

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.

 

[Andrzejek]

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:[tt]\\ntsvr6\ABCD\ [/tt]on any computer.

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[roystreet]

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

 

[roystreet]

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.