Hello compsci_Jack,
However when I go to insert an OLE object, whatever object type I select...
What types of files are you attempting to insert?
Be aware that embedding OLE objects can lead to extreme bloat (growth in
database size), which is why most developers avoid this practice. The folks
at ammara.com claim that one can use the ADO GetChunk and AppendChunk methods
to load raw-binary (BLOB) data without this overhead. I have not experimented
with doing this. Here is a link to their page, where they discuss this (I am
not ready to endorse their product, simply by providing this link):
http://www.ammara.com/articles/imagesaccess.html
The route that most developers use is to store the path to the file in one
field, and the actual filename in another field. This way, you can easily run
an update query to update the path, should you decide to change the location
where the files are stored. You can concatenate ("add together") these values
on-the-fly, using VBA code. You can even store the text for a hyperlink in a
third field, and concatenate all of this together into a working hyperlink at
run time, as needed. I find storing the pieces of a hyperlink in seperate
text fields easier to manage than trying to store the entire hyperlink in a
special memo field with datatype of hyperlink. Although there is VBA code
required to put the pieces back together into a clickable link, I find it
much easier to update the link properties when the need arises.
Anyway, due to the severe bloat issues associated with embedding OLE
Objects, you might want to re-think your strategy. Also, it can be very
difficult to extract images that are embedded in OLE Objects, say if you
later decide that you want to send an embedded image to someone.
Tom
_________________________________________
:
Thank you, however I am not running Norton antivirus. I disabled my antivirus
incase the one I have had a scripting protection, however it did not solve
the problem.
_________________________________________
:
Any chance you are using Norton AntiVirus on your PC? Here is a KB article
that discusses this error message when attempting to embed or link a Word
document in Access. I don't know if Norton AntiVirus could cause a similar
problem when attempting to embed or link other types of files:
http://support.microsoft.com/?id=295824
The only other KB article I could find, which might be helpful to you, is
this one:
http://support.microsoft.com/?id=207692
Tom
________________________________________
:
I have created a table with an OLE object so that I can insert images into my
tables, so they can be viewed in forms. However when I go to insert an OLE
object, whatever object type I select I get an error saying:
"A Problem occurred whilst Microsoft Access what communicating with OLE
Server or ActiveX Control. Restart the OLE server outside of access. Then
try the original operation again."
Please help me on how to do this...
