Upload images to Access database

[. . . . .]

How can I easy upload picture to an MS access database.

[Atrax]

this is generally a bad idea. Access is inefficient enough without
cramming it full of OLE objects - and pulling them back out is hardly a
trivial tasks (Access wraps them in an OLE header which needs to be
removed before display)

hence, generally it's not a great idea to put images in an Access DB.
store the path and put the images in the filesystem.




________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Anton Deve]

Hello,

Active Image home page: [url]http://www.tonec.com/download4.html[/url]

writedb.vbs
======
Dim im, rs
Set im = CreateObject("ActiveImage.Images.1")
im.ReadFromFile "C:\AI\diagram.png"
Set rs = CreateObject("adodb.recordset")
Set conn = CreateObject("adodb.Connection")
conn.Open "tonec"

rs.Open "pictures", conn, 2,3
rs.AddNew
im.WriteToDatabase rs.Fields("Bitmap")
rs.Update
rs.Close
im.DestroyImage
Set im = nothing
======

You can download the demo version of AI and see whether it works for you or
not.

Anton Deve

AI Support
Tonec Inc.

". . . . ." <webmaster@mail.ru>
news:uDzmgZ$SDHA.632@TK2MSFTNGP12.phx.gbl...

> How can I easy upload picture to an MS access database.
>
>

[Bullschmidt]

Here is a resource for letting the user upload a file which is something
that was unfortunately not built into ASP:

ASP File Upload Using VBScript by John R. Lewis - 7/10/2000
[url]http://www.aspzone.com/articles/john/aspUpload[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[John Smith]

I have a good sample:
[url]http://www.dalun.com/ftp/fupload.zip[/url]

Once you get the safe array of the image, you can do putchunk call to your
db. sample code included.

". . . . ." <webmaster@mail.ru> wrote in message
news:uDzmgZ$SDHA.632@TK2MSFTNGP12.phx.gbl...

> How can I easy upload picture to an MS access database.
>
>