OLE Objects from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 18 Jul 2008 14:42 GMT

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

Reply to this Message

Sylvain Lafontaine - 20 Jul 2008 07:28 GMT

> 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.

Signature

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

> Hello All,
>
[quoted text clipped - 12 lines]
>
> Rob

Reply to this Message

Rob - 21 Jul 2008 15:40 GMT

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

> > I have placed an unbound object control on a form that uses the OLE object
> > field from the table
[quoted text clipped - 24 lines]
> >
> > Rob

Reply to this Message

Sylvain Lafontaine - 21 Jul 2008 18:06 GMT

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.

Signature

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

> Sorry Sylvain,
>
[quoted text clipped - 50 lines]
>> >
>> > Rob

Reply to this Message