Opening OLE object/documents locks up form

[satdist]

I have a performance log database used to monitor employees
performance issues throughout the year. One table has an OLE object
field so I may drop in documents (log entry form) related to the
specific issues for that entry. I need the employee to be able to open
and view any documents I may have dropped in. I made a form that
returns current user entries( there may be numerous entries) and when
I dbl click a document it opens but the form freezes up after closing
that document. I need to be able to view any and all of the available
documents for any given user. Thanks for any help.

 

[Stephen Lebans]

Which application is registered to act as the OLE Server for these
documents?

Did the form always freeze when you attempted to activate the embedded
Documents? Have you tested a sampling of the existing records to ensure the
problem is widespread?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[satdist]

Thank you for the response, you may have to clarify your first
question. The back end is on a shared drive and the front is an MDE
file on the user's workstation, if that is of any help. When opening a
log entry form the user and myself have the opportunity to drag and
drop a file into a document field. This was the intention of this
field. I wanted the user and admin to be able to just click on any
given entry that had documents and be able to review the document. If
there are four entries with documents you can only open and view the
first one you select. When you close the document the form locks up
any further activity. I hope this helps, thanks agian.

 

[Stephen Lebans]

Let's try again.
What application(s) opens when you doubleclick to open/edit the embedded
documents?


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[satdist]

Mainly email messeges(outlook) pdf files(adobe) possibly a short cut
to intranet information(html) and microsoft office documents(2k2)
I hope this helps thanks.

 

[Stephen Lebans]

So is every different document type locking up the form when you exit the
OLE Server app that is displaying the document?

I have seen the behaviour you describe caused by AntiVirus software. Just to
eliminate this possibility shut down your AV app, restart Access, and see if
you can now insert documents without error.

In order to remove corruption as a possible cause have you tried to create a
new form and then insert some documents?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.