Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    embedding Pictures (Access 2000)

    Hi,

    one of or members writes"

    Would you be able to help me with an MS Access problem (Access 2000)?

    I'm having trouble with linking and embedding objects in the various Access
    databases I have created (and in other programs). The objects I want to link
    are either pictures or
    sound files. I don't know what has happened to Access or to something in my
    computer setup, but pictures are inserted as packages rather than content,
    which means that I see only an icon, which when I double click it activates
    the associated program and shows me the picture (or rather part of the
    picture). At the moment, the sound files are working, but sometimes it has
    done the same thing when I insert a sound file (this is a different Access
    database from the one with the pictures), that is, it inserts an icon which
    activates Windows Sound Recorder on double clicking.

    The pictures are inserted into the form as a bound object. The property box,
    under the 'Data' tab, shows
    'Display type: content'
    'Update Options: Automatic'
    'OLE type allowed: either'
    'Enabled: yes'
    'Locked: no'

    I read in the help file, under 'Troubleshoot pictures and other OLE objects
    on forms and reports', subsection 'I want to see the content of my object in
    my form or report but I get an icon instead', that the solution to this is
    to:

    1. Open the form in Design view or the report in Design view.
    2. Click the icon.
    3. On the Edit menu, point to the appropriate Object command (for example,
    point to Worksheet Object for a Microsoft Excel object), and then click
    Convert.
    4. In the Convert dialog box, clear the Display As Icon check box.

    however, when I open the form in DESIGN view and click on the control where
    I want the picture, there is no item 'Object command' under the Edit menu.
    When I look at the form in FORM view and click on the appropriate control
    there is an item at the bottom of the the Edit menu which says 'Package
    Object', with a sub-menu. This sub-menu then has the 'Convert...' item, as
    mentioned above, but with no other Object commands than 'Package' to choose.
    The convert dialog box also already displays the Display As Icon check box
    as cleared.

    When I start up any of my Access databases, I get the following warning
    dialog box:

    "Cannot find the file <pathfilename.mdb> (or one of its components). Make
    sure the path and filename are correct and that all required libraries are
    available."

    Now, the .mdb file is obviously there, as it gets opened, and the path and
    filename are obviously correct, but I've no idea what other libraries are
    supposed to be there. I have been running Access like this for about a year
    now. It complains as above when it starts up, but I just click on OK and it
    goes ahead and works perfectly well - apart from the OLE problem above, of
    course. I have reinstalled Access, in fact I think I even tried reinstalling
    the whole of Office, but I still get the same warning.

    Do you think this warning and the OLE problem are related?
    What do you think I can do?

    I should add that I do have some pictures correctly displaying in this
    database. I must have put them in before the problem manifested itself, but
    I'm not sure at which point that started.

    Thank you for your help.

    Bob Wahlen

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: embedding Pictures (Access 2000)

    Is this your problem or something someone has asked for help on? You haven't included any information on service packs, Windows version, security patches or anything else that might help define the issues.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: embedding Pictures (Access 2000)

    Charlotte:

    I am seeking help for another person. I will write back and ask for the information you requested.

    TIA for your help.

    Bob Wahlen

  4. #4
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: embedding Pictures (Access 2000)

    Charlotte

    Answers:
    OS Win2000
    Service packs - I haven't installed any
    No Security Fixes

    Bob Wahlen

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: embedding Pictures (Access 2000)

    This could be something as simple as a corrupted database - has it been compacted and repaired recently?
    Wendell

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: embedding Pictures (Access 2000)

    Well, I have to say that anyone who hasn't applied any service packs or patches is risking a lot. At the very least Office 200 SR-1 fixed some problems with the vanilla version of Access 2000. With respect to the rest, it isn't a single question , it's a whole series of them and many aren't very clear. It would be better to post specific questions about specific issues rather than something like this. Frankly, a long and comprehensive plea for help like this one doesn't necessarily attract a lot of volunteers, since not everyone is willing to wade through it to try and determine the actual questions. Here are some more questions for the user:

    1. What file format are the pictures in? "Picture" is not helpful. Is it a jpeg, a bitmap, a gif file, or what? 'Package Object' suggests that it was inserted by using the Insert menu and selecting a particular type of Object or a specific file into a table, not simply selecting "Picture" and inserting it into a form. There is a huge difference between an object embedded on a form and an object stored in an OLE Object type field in a table.

    If an object was inserted, then the edit menu for that object will display an item like "Bitmap Image Object" in design view and that item will have a submenu of the things you can edit. If there is no object *in* the bound OLE control, then you won't see that item on the menu. It doesn't apply to the control, it applies to the object in the control.

    2. There is no way to see a sound file in an OLE control, so exactly what is the user trying to do with it on a form or report?

    I doubt seriously that the
    <hr>"Cannot find the file <pathfilename.mdb> (or one of its components). Make sure the path and filename are correct and that all required libraries are available."<hr>
    problem is related to the OLE issue, but anything is possible. Typically, that error has a number of reasons, including multiple versions of Access on the same machine. Without more details, it isn't possible to ferret out the actual situation that applies. Here are a couple of articles that might offer some possibilities:

    ACC2000: Double-Clicking Shortcut to Access 2000 Object Starts Access 97 Instead

    PRB: "Cannot Find the File <FilepathFilename.mdb> (or One of Its Components)." Error Message While Opening .MDB File from Windows Explorer
    Charlotte

Posting Permissions

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