473,320 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Remove OLE Information for Images in DB

Bob
Hello:

I'm woundering if anyone can lead me to a tech article on how to remove the
OLE header from an images that get stored in an SQL image field via MS
Access forms.

I cannot use an ASP upload page since the user will be using an Access form
and does not want to jump around from Access to a web browser do do data
entry.

I'm not worried about performance because it's not a very big DB and the
server has plenty of hardware.

TIA

Bob
Jul 19 '05 #1
5 2750
> I'm woundering if anyone can lead me to a tech article on how to remove
the
OLE header from an images that get stored in an SQL image field via MS
Access forms.


This is one of the reasons I always recommend storing images on the file
system, and only their *location* in the database. Especially if the
database is Access.

See http://www.aspfaq.com/2149
Jul 19 '05 #2
Bob
Aaron:

Thanks for the info but if you read my posting you would have seen that I'm
storing the data in SQL via Access forms.

I've seen an SQL server DB with a soapware front end with 150,000 records in
it and the patient charts are stored as OLE Images and the thing is quite
fast on a single P4 so it should be OK on my Duel P4.

As for the rest, I know about that stuff and I don't care for a response
telling me what I should and should not do as you would have also known had
you read my posting in it's very short entirty.

All I need to know is where I can find an article that will help me do it.

Thanx

Bob
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:OI**************@TK2MSFTNGP09.phx.gbl...
I'm woundering if anyone can lead me to a tech article on how to remove

the
OLE header from an images that get stored in an SQL image field via MS
Access forms.


This is one of the reasons I always recommend storing images on the file
system, and only their *location* in the database. Especially if the
database is Access.

See http://www.aspfaq.com/2149

Jul 19 '05 #3
> All I need to know is where I can find an article that will help me do it.

Maybe you could try a web search, since you're clearly not interested in the
opinions of mere humans.
Jul 19 '05 #4
Bob
Chris:

Your a life saver !! That did the trick

Thank you

Bob
Jul 19 '05 #5
> Your a life saver !! That did the trick

Yep, having the ability to search the web is under-rated.

Nothing against Chris, of course.
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: lawrence | last post by:
In my style sheet I've set the links like this: a:link{ text-decoration:none; } I did that for the pseudo classes and I also did that for the image tag. Yet there are still link lines...
9
by: Ken | last post by:
I am trying to create one image using JavaScript; then later in the script remove the image - not just remove the src. The following creates the image, but I have been unable to remove it. How...
19
by: Steve Franks | last post by:
I am using VS.NET 2005 beta 2. When I run my project locally using the default ASP.NET Development Web Server it runs using a root address like this: http://localhost:11243/testsite/ However...
2
by: M O J O | last post by:
Hi, How do I add and remove PART of the RTF-text in a RichTextBox? If I use... MyRichTextBox.Text = "New text" & MyRichTextBox.Text .... then all my RTF (higlight, bold, underline and so...
3
by: Kentor | last post by:
Hello, I'm looking for a script that will be javascript/php compatible that will take existing images from a database and will allow editing/removing/adding new images. If JS is on then it should...
1
by: sgately | last post by:
HI All, I am not an HTML programmer, just used a template to create my website. On the website it had a built in Contact Form quickmail option. I do not know how to have information forwared to my...
0
by: dolittle | last post by:
Hi, I'm embedding a last.fm flash widget. I want to be able to remove it from the page using javascript. I've tried to delete the html element that contains the code but it keeps playing in...
22
by: dfm | last post by:
Hi, I cant change the header to display images from a database. It's giving me this error : Warning: Cannot modify header information - headers already sent by (output started at...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.