• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

ASP & access 97

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
soares
Asked:
soares
1 Solution
 
MasseyMCommented:
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
 
sybeCommented:
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
 
soaresAuthor Commented:
I will try. Anybody can send mre an source example ?
sandro@bins.com.br
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now