Automated update

[Dominic]

I am trying to update a table in my access database. I had
created an append query to fill in some of my fields. I
still have empty fields for my product table ieicture
and description. I have the various gif files for the
pictures which I want to be added to my picture field
which is define as an ole object. the file name is the
item number. Is there anyway I can write some kind of
query or code to examine the file name and then find the
item in my table.

My description files are similar, I have various files
named with the item number.

Any help is appreciated, I now I posted it in the wrong
area so I apologize because I didn't know where to post it

 

[Van T. Dinh]

Access database files tend to bloat very badly when OLE objects are stored
in the database files.

Most database developers store the OLE objects separately and simply store
the path to the OLE objects in the database.

HTH
Van T. Dinh
MVP (Access)