Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

MS Access 2003 - OLE Server Problem


(!)

IMTanuki's Avatar
IMTanuki IMTanuki is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Mar 2010
Experience: Advanced
24-Mar-2010, 09:59 PM
MS Access 2003 - OLE Server Problem
Hi,

I am using MS Access 2003 / XP and I'm having the following problem:

In any OLE Object field:

- I can insert a new object (e.g. Excel, Word)
- I cannot insert an object from an existing file.

Error Message:

"A problem occurred while <mdb name> was communicating with the OLE server or Active X Control."
"Close the OLE server and restart it outside of <mdb name> ..."

Note - this feature was previously working.

Troubleshooting to Date:
- I can reproduce this problem in any other mdb, including Northwind.
- I CANNOT reproduce this problem in any other MS Office program (i.e. I can successfully insert objects in Excel, etc.)
- I performed MS Office repair function from Setting / Add Change Programs.
- I completely uninstalled and reinstalled MS Access.
- I ran Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\Triedit\Triedit.dll".

Any ideas? I'm stumped...

Thanks,

Brooks

Last edited by IMTanuki; 24-Mar-2010 at 10:12 PM..
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,668 posts.
 
Join Date: Mar 2005
Location: UK
25-Mar-2010, 05:47 AM
Brooks, have you looked at the VBA Editor's Library References?
IMTanuki's Avatar
IMTanuki IMTanuki is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Mar 2010
Experience: Advanced
25-Mar-2010, 07:00 AM
It's a sizable doc. Any suggestions where to look?

I think this is an environmental problem (e.g. corrupted registry), since I  previously I have been able to insert existing objects into the database a nd now I can't, even using the sample database...
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,668 posts.
 
Join Date: Mar 2005
Location: UK
25-Mar-2010, 07:18 AM
The VBA Editor is opened using Alt + F11. On it's main menu goto Tools>References and look for
Microsoft Access Object Library
Microsoft AcitveX Data Objects Library
OLE Automation
Make sure that they are ticked and not "missing"
IMTanuki's Avatar
IMTanuki IMTanuki is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Mar 2010
Experience: Advanced
25-Mar-2010, 11:35 AM
They were all checked.

I haven't changed anything in Access and this feature was working a week ago...
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,668 posts.
 
Join Date: Mar 2005
Location: UK
25-Mar-2010, 11:41 AM
I would suggest that you check to see if there have been any "Updates" of any Programs around the time that it stopped working.
Would you like to post or email the database to have it checked on a different Computer?
IMTanuki's Avatar
IMTanuki IMTanuki is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Mar 2010
Experience: Advanced
25-Mar-2010, 12:12 PM
thx - I'm pretty sure this is not an mdb-specific issue, as I can reproduce the problem in the Northwind sample db.

I'm thinking of restoring to a checkpoint a week ago - but since I just reinstalled MS Access and "repaired" MS Office, I'm wondering if that will screw up the registry...i.e. - the registry will be restored to a point that may not recognize that latest install / repair of Access and Office.

Any thoughts on that?

Thx for your ideas.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,668 posts.
 
Join Date: Mar 2005
Location: UK
25-Mar-2010, 12:26 PM
See this thread for how Access can get messed up by the Registry being updated by other programs, I know it is not the same as your problem, but is just an example.
http://forums.techguy.org/business-a...not-close.html
IMTanuki's Avatar
IMTanuki IMTanuki is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Mar 2010
Experience: Advanced
25-Mar-2010, 07:44 PM
Interesting - I think you are right about the update. But note the result of your colleagues attempt to reinstall Office:

"Well, I guess I've screwed myself. I uninstalled Office 2000, then reinstalled it from my original CDs, but when I go to M$'s Office update site for 2000, ever update ends in an error that "the expected version was not found". So I can't update anything. And to compound the issue, the problem with Access still exists. So the problem is with WINDOWS, not with Office. It's beginning to look like I will have to wipe everything out, reinstall Windows and reinstall all my programs. Takes 1-2 full days."

This is what makes me nervous...
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
insert object, ms access, ole server

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!


Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2