November 19, 2002 at 6:17 am
I have finally managed to store a bmp picture file into SQL Server Hurrah! However its purpose is to store pupil pictures that can be seen by teaching staff when entering exam results. We use Access 2000 for all reports, forms etc and link into the SQL Server via linked tables with ODBC. This works perfectly for everything but (you guessed it) the stored picture files. Although the image box and links are displayed in a report there is no picture to be seen. Am I chasing rainbows with this?
It was hard enough to store the pictures in SQL but it seems just as bad trying to view them I am a network guy and not a programmer so this is all a little above me although my use of Access is good. Any friendly gurus out there?
November 22, 2002 at 8:00 am
This was removed by the editor as SPAM
November 22, 2002 at 8:30 am
Hi,
what version of sql server?. In sql 2000 in northwind database, in the table employee there is a column photo, which has pictures. I created a linked table to this table and created a report that shows the picture without doing additional coding.
The recordsource of the form is set to the linked table.
the boundobject frame's control source is set to the column with te picture.
the display type is set to content.
hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply