ASP Upload file to Access Database

[junkster79]

When users inout file to form, only file path name is being stored rather than actual file. Any ideas??
Thanks in advance!
Heres the code I'm using..

<input type=file name=&quot;assignment_att&quot;>

Open DB Connection etc, then...

rsRecordSet(&quot;assignment&quot = Request.Form(&quot;assignment_att&quot
rsRecordSet.Update

 

[dbrom]

You mean you want to store the actual file in the database?

If so, then

1) I am not sure you can do it in Access
2) It is not a very good idea - the database is going to be pretty hard to manage...

When I upload files, I only record their names in the DB, and then store them as actual files on the HD. I came up with the folder naming system based on persons ID that allows me to have a separate folder for each 50 people :

I name my folders 1250-1299, 1300-1349, etc.

This way I am not dumping all of my files in the same folder, because sooner or later it will become unmanagable (it will take a lot of time to retrieve a list of files in FTP client, for instance)

Do you have any specific reasons for actually storing files in the DB? <Dmitriy>
dbrom@crosswinds.net

 

[junkster79]

This is for a project I'm doing.
Students must submit assignments on-line, either by copy and paste into a text area, or by submitting as an attachment. Student records are stored in Access, hence the reason for using that. As there will be less than 50 records, and one file attachment per record, it shouldnt be too unmanageable.

 

[vasah20]

did you change your form type to multipart/data? I don't remember the exact syntax to do it, but it should have accompanied your FTP component... leo

------------
Leo Mendoza
lmendoza@garbersoft.net