Display Picture in FP2000 from Access2000 database

[DK Bowker]

I have an Access2000 employee database that I would like to add a field to
that contains a picture of each employee. That way, when someone clicks on
a the employee's name on our ASP website, they will be taken to a detailed
display about the employee--including the picture. I know how to do this
without using a picture, but I really want to add it if possible. Here are
my questions. 1) How do I setup Access2000 with a field that will contain
an image of the employee and configure it properly for use with FP2000
database results? 2) Once that is done, how do I format the database results
in FP2000 to display the image along with the other fields?

Thanks in advance for any and all help.

DK Bowker
bow...@wsu.edu

[Vidar Petursson]

Hi

Store only the filename in the db

Then in your asp ( JScript )

Response.Write("<img src='IMAGEPATH/" + rs("picFileName") + "'>");

Of course you would check if a picture(picFileName) is present in the DB..

You could have a webpage where the employee could modify his/hers info
& upload picure(s) etc...

Storing the image in the db will only make it slower & more difficult to
manage ( IMHO )

--
Best Regards
Vidar Petursson - MVP
http://www.icysoft.com
The...@icysoft.com
icy...@vortex.is

No matter where you go there you are.
-
DK Bowker <bow...@wsu.edu> wrote in message
news:OEdkCNfu$GA.187@cppssbbsa04...

[Bob LaGarde]

There is a method for managing binary data in asp however I think in the
long run Vidar is correct. It is much more manageable to store file
references in the db and then call the files in a link reference. Try
searching on the ASP list archive at www.15seconds.com for "binary" or
"image" if you want to pursue displaying the binary data you already have in
the db.

Bob
StoreFront E-Commerce for Microsoft FrontPage
www.storefront.net