Hello All,

I use SQL 2005 as the back end for an Access application. I have set up an
image field in SQL which translates to an OLE Object field in Access
(exactely what I want). I have placed an unbound object control on a form
that uses the OLE object field from the table. When I right-click and insert
object I have a problem. I can choose to create from file, browse and select
the file. I am also choosing to link to save space. When I click on okay
Access hangs and I have to stop the task. If I
set up a new table in Access with an OLE Object field and use it there are
no problems - only with SQL. Any suggestions?

Rob

> I have placed an unbound object control on a form that uses the OLE object
> field from the table

An unbound object control? I don't understand: unless you want to access a
local file on your machine or on the network, you should use a bound object
control. Also, you cannot choose to link to save space because other people
on the network might no be able to access the image. Finally, don't forget
that using an OLE Object field in Access will drag the performance down
seriously. Access 2007 is supposed to be less problematic than previous
versions of Access on this aspect but even with A2007, don't expect any
miracle in term of speed and space when using images with Access.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Rob" <Rob@discussions.microsoft.com> wrote in message
news:17CEFA11-30A6-4988-9794-A2CAEFDC3DFF@microsoft.com...
> Hello All,
>
> I use SQL 2005 as the back end for an Access application. I have set up
> an
> image field in SQL which translates to an OLE Object field in Access
> (exactely what I want). I have placed an unbound object control on a form
> that uses the OLE object field from the table. When I right-click and
> insert
> object I have a problem. I can choose to create from file, browse and
> select
> the file. I am also choosing to link to save space. When I click on okay
> Access hangs and I have to stop the task. If I
> set up a new table in Access with an OLE Object field and use it there are
> no problems - only with SQL. Any suggestions?
>
> Rob
>

Sorry Sylvain,

I meant a bound object control. This control is bound to the field for the
picture. If I can't right-click and insert object and link then what is this
good for? I never had any problems in Access doing this with jpeg files.
They would show up in the control and since they were linked they did not
bring the speed down any. Now that I am using SQL for the back end the
program hangs. Any suggestions as to the best way to show jpegs as part of
the record?

Regards,

Rob

"Sylvain Lafontaine" wrote:

> > I have placed an unbound object control on a form that uses the OLE object
> > field from the table
>
> An unbound object control? I don't understand: unless you want to access a
> local file on your machine or on the network, you should use a bound object
> control. Also, you cannot choose to link to save space because other people
> on the network might no be able to access the image. Finally, don't forget
> that using an OLE Object field in Access will drag the performance down
> seriously. Access 2007 is supposed to be less problematic than previous
> versions of Access on this aspect but even with A2007, don't expect any
> miracle in term of speed and space when using images with Access.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Rob" <Rob@discussions.microsoft.com> wrote in message
> news:17CEFA11-30A6-4988-9794-A2CAEFDC3DFF@microsoft.com...
> > Hello All,
> >
> > I use SQL 2005 as the back end for an Access application. I have set up
> > an
> > image field in SQL which translates to an OLE Object field in Access
> > (exactely what I want). I have placed an unbound object control on a form
> > that uses the OLE object field from the table. When I right-click and
> > insert
> > object I have a problem. I can choose to create from file, browse and
> > select
> > the file. I am also choosing to link to save space. When I click on okay
> > Access hangs and I have to stop the task. If I
> > set up a new table in Access with an OLE Object field and use it there are
> > no problems - only with SQL. Any suggestions?
> >
> > Rob
> >
>
>
>

Nope. The manipulation of images under Access if fully bugged on many
(most?) installations and using an ODBC linked tables often make things
worse. For example, on my machine, unless I transfert the image via the
clipboard, I see nothing but an icon about the type of the image.

I suppose that there is a problem in your case with the program associated
with the display of the images. By changing the association of jpegs with
another type of program (in Windows), it's possible that you might solve
your problem.

Many people don't use this control because of the multiple problems
associated with it and instead will use something else dbpix from Ammara ($)
or will use the unbound object control and load the image into the control
using VBA code.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Rob" <Rob@discussions.microsoft.com> wrote in message
news:3365822D-658A-48FB-A19F-8FB426334041@microsoft.com...
> Sorry Sylvain,
>
> I meant a bound object control. This control is bound to the field for
> the
> picture. If I can't right-click and insert object and link then what is
> this
> good for? I never had any problems in Access doing this with jpeg files.
> They would show up in the control and since they were linked they did not
> bring the speed down any. Now that I am using SQL for the back end the
> program hangs. Any suggestions as to the best way to show jpegs as part
> of
> the record?
>
> Regards,
>
> Rob
>
> "Sylvain Lafontaine" wrote:
>
>> > I have placed an unbound object control on a form that uses the OLE
>> > object
>> > field from the table
>>
>> An unbound object control? I don't understand: unless you want to access
>> a
>> local file on your machine or on the network, you should use a bound
>> object
>> control. Also, you cannot choose to link to save space because other
>> people
>> on the network might no be able to access the image. Finally, don't
>> forget
>> that using an OLE Object field in Access will drag the performance down
>> seriously. Access 2007 is supposed to be less problematic than previous
>> versions of Access on this aspect but even with A2007, don't expect any
>> miracle in term of speed and space when using images with Access.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>
>>
>> "Rob" <Rob@discussions.microsoft.com> wrote in message
>> news:17CEFA11-30A6-4988-9794-A2CAEFDC3DFF@microsoft.com...
>> > Hello All,
>> >
>> > I use SQL 2005 as the back end for an Access application. I have set
>> > up
>> > an
>> > image field in SQL which translates to an OLE Object field in Access
>> > (exactely what I want). I have placed an unbound object control on a
>> > form
>> > that uses the OLE object field from the table. When I right-click and
>> > insert
>> > object I have a problem. I can choose to create from file, browse and
>> > select
>> > the file. I am also choosing to link to save space. When I click on
>> > okay
>> > Access hangs and I have to stop the task. If I
>> > set up a new table in Access with an OLE Object field and use it there
>> > are
>> > no problems - only with SQL. Any suggestions?
>> >
>> > Rob
>> >
>>
>>
>>