microsoft access images

[davfury]

Does anybody know how to retrieve the access file of a OLE link to a jpg or bmp file ?

In fact, I want to create a form with a picture tooken from a 3/4 disk. The user is really not friendly with access and he takes pictures with a numeric camera for some objects. He has then to create this object to the database thanks to a form, but it's nit easy to add the picture in a normal mode.
If I use an OLE compnant, he has to find the good picture and this picture will be add to the database. This solution isn't good for me because of the size of the database.

So how can I retrieve the access file (the real access, not the OLE access - like 194497444 -), or does anybody has a suggestion to create a form simple to use with the picture ?

thanks.

 

[Aivars]

Hi!

You're right that adding picturs into table isn't best solution. You can create links to pictures what are located on your disk.

When you insert object into table you can choose Create from file and check ckeckbox Link.

More information look at site

http://msdn.microsoft.com/library/officedev/office97/output/F1/D2/S5A023.HTM

Aivars

 

[SyedAqif]

Hi

If u mean to show a picture (stored in ur pc) with its relevant name on runtime without actually making it a part of ur database, then u can do like this.

Create a folder e.g Pics in ur hard drive and start to store the pictures in that folders n u can name pictures as 124.gif etc.

Then Create a form with a text control and an image control e.g txtname and imgshow. n place a button n write code behind its click even

Dim strpath As String
Dim strext As String
Dim strfile As String
If Picid > 0 Then
strpath = "C:\Pics\"
strfile = txtname
strext = ".gif"
strpath = strpath1 & strfile & strext
'MsgBox strpath
imgshow.Picture = strpath
End If


Now whatever name of picture u'll write access will try to find that image in Pic directory n will show at runtime w/o storing it on database Simple

Cheers!
Aqif