Inserting a JPEG

Sorry the below is all in MS Access 2000


I want to insert a jpg into my table. First off I tried
Insert object - create from file
and then browsed to my jpg.
This seemed to have worked, but on closer insepection it had converted the image to an MS image.
I found a work around my doing the following
Insert object - create new -- new package
I then added the jpg to the package and inserted it.

My question is does anyone have any ideas how to automate the above actiion using VBA. Or if theres an easier way to insert JPEG's.

Any help wopuld be great.

Not sure this is exactly what you want but... in the database forums there is a sticky post of how to store files (including Jpegs) into dbs (like Access).

If however you only need the name of the file and its path, and the shared area is accessible to all those who need it, then this makes a smaller db... ;)


Vince