Solved

ASP & access 97

Posted on 1998-10-15
3
159 Views
Last Modified: 2013-12-25
I am starting using MS Access97 to create ASP. Why my pictures fields dont work ok atfer convertion. What Should I do ? If possible I want an example of MDB that I can save like ASP format.
0
Comment
Question by:soares
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
MasseyM earned 100 total points
ID: 1829102
You cannot export pictures from an access database to ASP... The picture only work from a BLOB which is only avaliable from the SQL server databases... The best solution for an access database is to store the link to the graphics and just reference it...
0
 
LVL 28

Expert Comment

by:sybe
ID: 1829103
soares,

Unlike what MasseyM states, you can store pictures in an Access OLE-field. And retrieve them from there using ASP. However, if you store the pictures by copy & paste, then it won't work, because Access converts pictures that are stored in this way to .BMP (and keeps a copy of the original), so the binary code is really messed up.

To store pictures as binary code in an OLEfield, you have to write your own module in VBA (it's not so hard), or use a server-object as SA-FileUp.


0
 

Author Comment

by:soares
ID: 1829104
I will try. Anybody can send mre an source example ?
sandro@bins.com.br
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Auto-indent certain lines in Notepad++ 10 144
[Internet] Batch mode for shortening long URLs 3 23
Deploy restore partition 1 25
CSV file copy field 1 to field 2 2 35
This tutorial will discuss the log-in process using WhizBase. In this article I assume you already know HTML. I will write the code using WhizBase Server Pages, so you need to know some basics in WBSP (you might look at some of my other articles abo…
It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question