|
-
July 13th, 2000, 06:37 AM
#1
Storing pictures in a database.
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
#2
Re: Storing pictures in a database.
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
#3
Re: Storing pictures in a database.
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|