PicturesInADataBase

[gbradley]

I have an Employee Database with quite a few pictures in it.

When I started out, I had a Casio QV-10-Picture Camera and with the Casio software.

I would just Copy the picture and then paste it ino my Photo table in Access97.

Well my old QV-10 has seen better days, so I need to do something.

When I try and paste a .jpg picture into the Access file, the file "blows up". What I mean by that is that it gets really big after just a few photos.
Even if I use jpgs that are the same size as the Casio pics ... 25KB.

Has anybody else had this type of problem, and have you got a solution?
Thanks

 

[tonnic]

Hi,

I have/had the same problem.

Now I'm saving the pictures on the harddrive and only the links are in the table.

 

[gbradley]

Now I'm saving the pictures on the harddrive and only the links are in the table.

Will you show me how you do that?
Thanks

 

[tonnic]

I'm sorry, I have made the database for a friend of mine, and I dont have a copy on my harddrive.

But I can describe it.

First the table:
In the table I had following columns: Link, Description, Date (when the picture was shot), event (party, tournaments, etc.)

Then I have made a form, where all of the above mentioned columns were shown.
With a VB-Script I changed the image-source of the picture always when i went to the next record.

I think the event-handler was "Current".

This line should always set the source for the actual picture: Me.[ControlName].Picture=me.[LinkControl]

Try it and replace [controlName] with the name of your picture control and the [linkcontrol] with the name of the textbox, where you give out the link.
I dont know why, but always when I tried to set the link directly - without link-textbox I got an error ...