Images in a database

[adamcoppard]

We are trying to create a database where by a user can insert a picture into the database, either as a link or in an actual file in the database. The user must then insert these with a browse button (like uploading online), kinda concept (must be easy). We looked into OLE objects, and hyperlinks, and after reading online guides, they never seemed to work right (we are using Access 2000). Is there an idiot proof way of getting pictures into an Access database?

Thanks

 

[Lightwave]

You could try this...

http://www.access-programmers.co.uk/forums/showthread.php?t=108698&highlight=image

As for idiot proof - ain't nothing that's idiot proof.

 

[adamcoppard]

That looks like half the solution. Two features that are kinda missing for us:
The picture insert form must go in with other data-types (we can build that), but it must create a new record.
Also, the picture must be printed as a picture in reports (we have to print off pictures for an id card).

TIA