Inserting pictures on msaccess database

[Pedro Maria Ferro da Cunha]

I spend a lot of time making 2 thousand pictures and saving them as an
article name. jpg.

I have a table with the article name and name of the file in jpg (format).

How can I make an instant attach to the database instead of adding picture
record by record... is any way possible to do that on msaccess?

Thank you

[xzzy]

Pardon my extra words, you appear to be from Portugal, I hope the extra
words will make the translation easier

It is far better to save the pictures as pictures and not in an Access mdb.
Access is bad at saving pictures in an mdb

try, this

Save the path to the pictures in the mdb and do this when you need a
picture:

Set MySet = CurrentDb().OpenRecordset("select * from [tblIMAGES] where
[PicName] = '" & MyName & "';", dbOpenSnapshot)
Select Case MySet.RecordCount
Case 1
Me.ctlItemPic.picture = MySet!PATH
Case Else
Me.ctlItemPic.picture = "C:\default.bmp"
End Select

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Pedro Maria Ferro da Cunha" <pf*****@iol.pt> wrote in message
news:10**************@news.iol.pt...

I spend a lot of time making 2 thousand pictures and saving them as an
article name. jpg.

I have a table with the article name and name of the file in jpg (format).

How can I make an instant attach to the database instead of adding picture
record by record... is any way possible to do that on msaccess?

Thank you

[Mike Storr]

If it has to go into a table, then I can think of only two ways, record by
record, or using the Dir() function to loop through the folder they are
stored in, then adding them record by record through a recordset in code.
Perhaps you're better off only keeping the path to the image in the DB?

Mike Storr

"Pedro Maria Ferro da Cunha" <pf*****@iol.pt> wrote in message
news:10**************@news.iol.pt...

I spend a lot of time making 2 thousand pictures and saving them as an
article name. jpg.

I have a table with the article name and name of the file in jpg (format).

How can I make an instant attach to the database instead of adding picture
record by record... is any way possible to do that on msaccess?

Thank you

[Larry Linson]

Download the sample databases from http://accdevel.tripod.com. They
illustrate three approaches to handling images in Access. You can embed the
programmatic method for embedding or linking in a VBA loop using the DIR
statement to find the names of the files. You may want to review the
included article which discusses considerations in choosing the method
appropriate to use in your application.

Larry Linson
Microsoft Access MVP
"Pedro Maria Ferro da Cunha" <pf*****@iol.pt> wrote in message
news:10**************@news.iol.pt...

I spend a lot of time making 2 thousand pictures and saving them as an
article name. jpg.

I have a table with the article name and name of the file in jpg (format).

How can I make an instant attach to the database instead of adding picture
record by record... is any way possible to do that on msaccess?

Thank you