Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsVB SyntaxEnterprise DevelopmentDatabase AccessControlsCOMWin APICrystal ReportDeploymentGeneralGeneral 2
Related Topics
VB.NET / ASP.NETMS SQL ServerMS AccessOther Database ProductsMore Topics ...

VB Forum / Database Access / September 2005



Tip: Looking for answers? Try searching our database.

Adding and retrieving MS Word documents in Access (via VB)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Perri - 25 Sep 2005 20:47 GMT
I've seen some threads that deal with Bitmaps, but what I want to do is:

Set a field in an Access database for OLE Object
Programmatically load and retrieve Word documents to/from this field

I'm using VB6 and Access 2000 - not against moving up to Access 2003 if I
have to.

Secondary question, when I DO add a new OLE Object field into the database
manually (Insert Object...from file) and try to embed a Word document into it
(in Access), it will load, but
I get an error when I try to move off the record or otherwise save the table:
"A problem occurred while Microsoft Office Access was communicating with the
OLE server."

When I close the table:
"A problem occurred while Microsoft Office Access was communicating with the
OLE server or ActiveX Control"
Mike Perri - 28 Sep 2005 05:41 GMT
Anyone? Maybe a Microsoft article I may have missed?

Thanks

> I've seen some threads that deal with Bitmaps, but what I want to do is:
>
[quoted text clipped - 14 lines]
> "A problem occurred while Microsoft Office Access was communicating with the
> OLE server or ActiveX Control"
Ralph - 28 Sep 2005 14:00 GMT
> Anyone? Maybe a Microsoft article I may have missed?
>
[quoted text clipped - 18 lines]
> > "A problem occurred while Microsoft Office Access was communicating with the
> > OLE server or ActiveX Control"

Have you tried posting in microsoft.public.access ?

Do the docs contain additional embedded "OleObjects"?

You might also look around for example where they stored Excel documents.

Although there are references all over the place that MSAccess CAN do this,
I never had any success the few times I tried it. As Word docs are generally
huge compared to the information they contain and MSAccess is file-based
anyway. I have always stored either the text or storagepath/filename, then
recreated the doc using text and template or opened the doc from ancillary
storage.

However, that doesn't answer your question does it. <g>

hth
-ralph
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.