how to store an image in a field with a query? 1

[WomanPro]

hello everybody,
I have a table in a database and a field of it need to be an image
how can I store an image with a query?

I have tried that
INSERT INTO Tracks ('C:\Documents and Settings\Neraidopetalouda\Τα έγγραφά μου\Η μουσική μου\moby.jpg') where TrackTitle='Mistake')

without effect? any help please?

 

[lameid]

I don't think you can do this with a query unless there is some function you can right to return the blob for the file and use it in your query.

It looks like you want to put the same picture in for a number of records. First I would suggest that rather than doing this, you consider storing the images separate and having a foreign key to retrieve images in your table.

That said if you really want to do this, as a one off, I would make a table that has one record, the image you want to update records with. Secondly I would use the field in this table to update the destination field in the target table. In this way you can avoid updating a bunch of records manually.

There are also examples around the net to load data in using a recordset and filestream.

 

[WomanPro]

no effect I have tried everythig, to be clear my talbe stores a TrackId, TrackName, Image
it's very important to have an image for each record. I don't believe that I can't do something

 

[lameid]

Microsoft's details...

http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx

What exactly have you tried? Do you have examples that do not work?

 

[WomanPro]

So is your opinion just to store only the filepaths of each image?

 

[lameid]

Generally people only store filepaths either as text or hyperlinks unless there is some need to do otherwise. The only time I stored this type of data in a database it was SQL server and I did that to store the support files that needed to be downloaded to the client and in the organization I was at this was easier than trying to get permissions set. In my case it was office docs but the same principle. In this case I had to read a filestream into the SQL connected ADO recordset... I don't have that code now but I believe I found an MS sample that I modifed to do it.

Storing long binary data (files) in a database is genrerally problematic. I had my several files(maybe 3 dozen) working in SQL Server and Access frontend without incident. Most certainly storing paths is better for your database performance.

 

[WomanPro]

maybe yes!!! I used a picture box and with imagelocation I loaded the image.
I need it in a listview, I will see how I will do that... I am using vb.net 2005 so ado, is pretty oldier technology. I have posted to vb.net 2005 for further assistance. Thank you much in advanced.