Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Location
    Wales
    Posts
    3

    Unanswered: MS Access OLE SErver

    I upgraded to Access 2002 from 97. All my Dbs were fine inc. linked photographs. Suddenly all the photos have disappeared and I get the follwoing messages. These are the messages I get when trying to A) look at a part of a form that should have a picture in it ( all pictures, except a Powerpoint one, have disappeared i.e. the link has gone) or B) when I try to re-link to the original picture again.

    Messages

    A) 'The OLE server isn't registered - please re-install'. I have reinstalled Access and also repaired Office to no avail.

    B) ' A problem occurred whilst MS Access was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside Access. Then try the original operation again in Access'. - I've no idea what they're talking about!

    Thanks for any help you can give.

  2. #2
    Join Date
    Apr 2003
    Posts
    31

    OLE Error

    i believe you need to add the reference "OLE Automation" into your VB code. if you don't know how, let me know.

  3. #3
    Join Date
    Apr 2003
    Location
    Wales
    Posts
    3

    Re: OLE Error

    Originally posted by eciabattari
    i believe you need to add the reference "OLE Automation" into your VB code. if you don't know how, let me know.
    Sorry don't know how to do this. Grateful for your help.

  4. #4
    Join Date
    Apr 2003
    Posts
    31

    Add Reference

    to add the reference, you'll need to do the following:

    1. start access
    2. once access has started, click "ALT+F11"
    3. this will bring up the "Visual Basic"
    4. click on "Tools > References"
    5. scoll down to the one you need and check the box to it.
    6. click ok
    7. close vb window

    let me know if you have any problems.

  5. #5
    Join Date
    Apr 2003
    Location
    Wales
    Posts
    3

    Re: Add Reference

    Originally posted by eciabattari
    to add the reference, you'll need to do the following:

    1. start access
    2. once access has started, click "ALT+F11"
    3. this will bring up the "Visual Basic"
    4. click on "Tools > References"
    5. scoll down to the one you need and check the box to it.
    6. click ok
    7. close vb window

    let me know if you have any problems.
    Thank ypu for the reply. However its already 'ticked'. I think that it has to do with the fact I opened all the pictures with Paint and copied and pasted them into a table (simple me). I can now do this with other programs ( ie MS PhotoEditor) but not with Paint. And my original pictures are still not showing up. Any ideas???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •