Inserting an Image

[Richard Wagstaff]

I'm trying to insert an image into a database, but when I browse to the
object I get the following error:

"The connection with the OLE server was losy, or the OLE server encountered
an error while you were using it."

I've seen a couple of posts suggesting a problem with Norton Anti-Virus
(which isn't installed on this computer) and the file association mapping
bmp files to MS Paint (which it is).

I'm obviously doing something wrong here. but for the life of me I can't see
what.

Could some kind soul point me in the right direction - I need to insert a
bmp file into a record. The pc is a test machine - not connected to the
Internet and the only software installed is Windows XP Pro & Office 2003
Pro. All uodates have been applied.

Many thanks.

Richard

 

[Arvin Meyer]

Try the following. It fixed a similar problem for me this morning.

Reregister ACCWIZ.DLL

it should be located in the same folder that the Access executable is,
normally this would be the following.

Start ... Run

regsvr32.exe "C:\Program Files\Microsoft Office\Office11\ACCWIZ.DLL"

You can also try checking for a missing reference for the OLE automation
library:

From a code window, Tools ... References
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Richard Wagstaff]

Many thanks for the response.

I re-registered ACCQIZ.DLL successfully and checked that OLE Automation was
checked.

Still no joy I'm sorry to say, I still get the same error.

I've also tried this on a second PC with exactly the same error so I'm
guessing it's not a local issue.

Richard

 

[Larry Linson]

How about considering an alternative to using OLE fields? That approach is
one of the three approaches to handling images in Access demonstrated in the
sample databases you can download from http://accdevel.tripod.com.

Larry Linson
Microsoft Access MVP

 

[Richard Wagstaff]

Many thanks indeed for the info.

Richard

How about considering an alternative to using OLE fields? That approach is
one of the three approaches to handling images in Access demonstrated in the
sample databases you can download from http://accdevel.tripod.com.

Larry Linson
Microsoft Access MVP