Ms Access, ASP : Storing images in db
cnerurkar | Posted 3:19pm 4. February 2005 Server Time |
Hi...!
I want to create a field in my Ms Access Database which can store image files of types GIF, JPEG or BMP.
Can someone explain me in simple words as to how I would go about doing this firstly in Ms Acess and then through ASP. I am quite familiar with both Ms Access and ASP and SQL (not good, but familiar and have an understanding now)
thanks...! |
cnerurkar | Posted 3:35pm 4. February 2005 Server Time |
Hi guys, I read somethings on the net and in the forum, and most experts recommed avoid storing images on a Ms Access Database, coz it affects the performance.
Could someone kindly help me with any other alternatives i could use...?
thanks
cnerurkar
steven290 | Posted 3:56pm 4. February 2005 Server Time |
what you do is store the file name in the db.
ex. using a file upload system you woulf upload the file to a directory(filesfolder) at the same time it would add the file name to a field. then you call it later
<IMG SRC="filesfolder/<%=filenamevariable%>">
cnerurkar | Posted 2:03pm 5. February 2005 Server Time |
Hi Steven290,
I have an idea of what you are trying to say. I will basically create a folder where the users will ipload their files.
can you tell me of any simple method that I can provide to enable the users to upload files to a specified directory, which will have WRITE access...!
steven290 | Posted 2:36pm 5. February 2005 Server Time |
below is a link of pure asp file upload (no component)
http://www.asp101.com/articles/jacob/scriptupload.asp
there are a couple of more out there, try google
cnerurkar | Posted 7:49am 8. February 2005 Server Time |
Hi Steven 290,
Thanks a million for the information. Although it did not work for me, just want you to know that i appreciate your help.
cnerurkar.
steven290 | Posted 8:16am 8. February 2005 Server Time |
post the code that didnt work for you, so we can try and help
durgabhushal | Posted 1:26am 5. May 2007 Server Time |
i want to learn how to send or retrive picture from ms access
enigma | Posted 2:05pm 5. May 2007 Server Time |
To All:
This topic was previously addressed and may I suggest that the search feature, that Alex coded for this site, be used?
http://haneng.com/Forums_Post.asp?id=3611
Cheers,
enigma
sarathe | Posted 11:13pm 16. March 2010 Server Time |
hi, i want to know how to store image in ms access database in java code
Reply to Post Ms Access, ASP : Storing images in db
|
|
|
