1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Access 2003 - OLE Server Problem

Discussion in 'Business Applications' started by IMTanuki, Mar 24, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. IMTanuki

    IMTanuki Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    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
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    Brooks, have you looked at the VBA Editor's Library References?
     
  3. IMTanuki

    IMTanuki Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    I&#65364;&#65287;&#65363;&#12288;&#65345;&#12288;&#65363;&#65353;&#65370;&#65345;&#65346;&#65356;&#65349;&#12288;&#65348;&#65359;&#65347;&#65294;&#12288;&#65313;&#65358;&#65369;&#12288;&#65363;&#65365;&#65351;&#65351;&#65349;&#65363;&#65364;&#65353;&#65359;&#65358;&#65363;&#12288;&#65367;&#65352;&#65349;&#65362;&#65349;&#12288;&#65364;&#65359;&#12288;&#65356;&#65359;&#65359;&#65355;&#65311;

    &#65321;&#12288;&#65364;&#65352;&#65353;&#65358;&#65355;&#12288;&#65364;&#65352;&#65353;&#65363;&#12288;&#65353;&#65363;&#12288;&#65345;&#65358;&#12288;&#65349;&#65358;&#65366;&#65353;&#65362;&#65359;&#65358;&#65357;&#65349;&#65358;&#65364;&#65345;&#65356;&#12288;&#65360;&#65362;&#65359;&#65346;&#65356;&#65349;&#65357;&#12288;&#65288;&#65349;&#65294;&#65351;&#65294;&#12288;&#65347;&#65359;&#65362;&#65362;&#65365;&#65360;&#65364;&#65349;&#65348;&#12288;&#65362;&#65349;&#65351;&#65353;&#65363;&#65364;&#65362;&#65369;&#65289;&#65292;&#12288;&#65363;&#65353;&#65358;&#65347;&#65349;&#12288;&#65321;&#12288;&#65360;&#65362;&#65349;&#65366;&#65353;&#65359;&#65365;&#65363;&#65356;&#65369;&#12288;&#65321;&#12288;&#65352;&#65345;&#65366;&#65349;&#12288;&#65346;&#65349;&#65349;&#65358;&#12288;&#65345;&#65346;&#65356;&#65349;&#12288;&#65364;&#65359;&#12288;&#65353;&#65358;&#65363;&#65349;&#65362;&#65364;&#12288;&#65349;&#65368;&#65353;&#65363;&#65364;&#65353;&#65358;&#65351;&#12288;&#65359;&#65346;&#65354;&#65349;&#65347;&#65364;&#65363;&#12288;&#65353;&#65358;&#65364;&#65359;&#12288;&#65364;&#65352;&#65349;&#12288;&#65348;&#65345;&#65364;&#65345;&#65346;&#65345;&#65363;&#65349;&#12288;&#65345;&#65358;&#65348;&#12288;&#65358;&#65359;&#65367;&#12288;&#65321;&#12288;&#65347;&#65345;&#65358;&#65287;&#65364;&#65292;&#12288;&#65349;&#65366;&#65349;&#65358;&#12288;&#65365;&#65363;&#65353;&#65358;&#65351;&#12288;&#65364;&#65352;&#65349;&#12288;&#65363;&#65345;&#65357;&#65360;&#65356;&#65349;&#12288;&#65348;&#65345;&#65364;&#65345;&#65346;&#65345;&#65363;&#65349;&#65294;&#65294;&#65294;
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    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"
     
  5. IMTanuki

    IMTanuki Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    They were all checked.

    I haven't changed anything in Access and this feature was working a week ago...
     
  6. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    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?
     
  7. IMTanuki

    IMTanuki Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    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.
     
  8. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
  9. IMTanuki

    IMTanuki Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    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...:(
     
  10. Sponsor

As Seen On
As Seen On...

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.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/912407