Click to See Complete Forum and Search --> : Storing pictures in a database.
July 13th, 2000, 06:37 AM
Help me please!! What I intend to do seems to be very easy, but I couldn't do it. I have one table(Access) with the path of some pictures. I would like to create a temporary table with the real images (OLE field in Access) instead of their paths. I'd tried to use the loadpicture function from VB, but it didn't work. If somebody could help me I would really appreciated it!!! Thanks.
Bye!
July 13th, 2000, 09:38 AM
For what it's worth, store the pictures' path and file name in the data field as you are currently doing. Storing OLE objects in Access can consume quite a bit of resources. A simple 44kb jpg file will take up nearly 1mb of space in your database. Add another 44kb jpg file and you use up another 1mb of space. Try it manually first, but you will find it is easier to save the path/file name in the data field and keep the actual picture in another location.
Hope this helps
July 13th, 2000, 01:11 PM
I know it consumes a lot os space, but it is only a temporary table. In fact I need to create a Crystal Report and, for each register there is a picture ( that at the moment I have only their paths) . Understood? Even that thanks for your reply!
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.