By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

How to store images as blobs when pasted into forms

P: 1
My database is bloated, and it's not the beer. The users wanted pictures on their forms, so I set up some OLE object fields and plonked them on the forms. Lo and behold the users went mad pasting jpg images from the web into the database. Result - chugging slowness. Desired outcome - speediness. Proposed method - use blobs. Problem - how?
I need efficient ways to:
1. convert what's there into blob format
2. adapt the form controls so that any further jpgs are converted into blobs when they are pasted into them.
Help! Before I explode!!
Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
My database is bloated, and it's not the beer. The users wanted pictures on their forms, so I set up some OLE object fields and plonked them on the forms. Lo and behold the users went mad pasting jpg images from the web into the database. Result - chugging slowness. Desired outcome - speediness. Proposed method - use blobs. Problem - how?
I need efficient ways to:
1. convert what's there into blob format
2. adapt the form controls so that any further jpgs are converted into blobs when they are pasted into them.
Help! Before I explode!!
In the interest of heading off explosions :-) This site purports to sell a software product that is going to solve all your troubles... http://www.ammara.com/start/aw/acces...cess&net=0&st=

This is a link to another thread that has additional links on this topic: http://www.thescripts.com/forum/thread690885-dbpix.html

Regards,
Scott
Sep 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.