Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Location
    Weatherford TX (Between Fort Worth and Abilene)
    Posts
    57

    Unanswered: Ole Field MS Access 2007 - Power point Object

    I recently upgraded from MS Access 2003 to MS Access 2007. In the database I had a table that had an OleObject field that I used for PowerPoint presentations. When you opened the table you could right click on the oleObject field and either open or edit the presentation. When you opened the table in datasheet view the ole field would show “Microsoft Presentation” or”Microsoft Word “ or whatever.

    After installing MS Office 2007 and I clicked on the OLE field my only option was to open (show) the presentation, there was no option to edit the presentation. I was storing the presentations in a field in a database and with Access 2003 I could open and edit the presentations as needed. ( I already know the best way to have done this would have been to link the presentation instead of embedding it – I don’t need anybody saying “I told you so”)

    I have essentially lost all of my presentations because I can no longer edit them. After playing around with Access 2007 I figured out that you could insert an existing power point presentation into you OLE field but after you insert it the field shows “Package” instead of “Microsoft PowerPoint”.

    Does anyone know of a way to get my power point presentations back into an editable format so I haven’t lost them forever?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I know you don't need to hear it... but I don't care since you understood yet ignored the reasoning. Perhaps it is too late for you to benefit, but it isn't yet too late for others.

    DON'T use OLE objects to store documents inside an Access database. This is a classic reason why. There are other reasons too. If you have OLE objects stored in a table... rescue them now and start using links to files instead.

    Please folks, learn and adapt... instead of understand and ignore.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    Quote Originally Posted by StarTrekker
    I know you don't need to hear it... but I don't care since you understood yet ignored the reasoning. Perhaps it is too late for you to benefit, but it isn't yet too late for others.

    DON'T use OLE objects to store documents inside an Access database. This is a classic reason why. There are other reasons too. If you have OLE objects stored in a table... rescue them now and start using links to files instead.

    Please folks, learn and adapt... instead of understand and ignore.
    They do have use as embedded but like everything you tale your precautions. I store Word docs as embedded OLEs. The docs are product comparisons which I supply with my DBs. The DBs create a folder and then install them as Word docs. Among other things it means someone can copy their DB onto disk, stick it on anothe computer in the bush etc and those Word docs can be created. Of course I don't delete the Word docs after they are embedded.

    Unless there is some special issue at hand, I don't understand why the thread starter still does not have his A2003 and his presentations.

    To me there is a very simple rule with Access...backup to the point of the ridiculous (it is easy to make a "one click" that will send it all over a network, date/time stamped etc) and never disguard anything you make. in recent years hard disk, both internal and external, has been so cheap etc.

    If you have very comprohensive backups for DBs then I like to store as much as possible in the DB. For example, my code that does Access to Word during the print phase, opens a new record in a Many table and copies and pastes the Word doc into a memo field. Sure, the formatting is lost but the document is available for every pience of correspondence ever sent to a client or prospect. Of course a SaveAs with date/time is done at the same time but the simple backup of the DB guarantees countless copies of any correspondence.

    I have essentially lost all of my presentations because I can no longer edit them. After playing around with Access 2007 I figured out that you could insert an existing power point presentation into you OLE field but after you insert it the field shows “Package” instead of “Microsoft PowerPoint”.
    Can you arrange to use A2003 again or perhaps get someone to do it. If don't have copies of your DB that are still in A2003 format, then that is a lesson.

    But I would imgaine there would be a way to import/export the table (s) out of A2007 and into A2003.

  4. #4
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    As to backup I came across the following just recently.

    http://www.members.shaw.ca/AlbertKallal/zip/index.htm

    For those who have not seen it produces a Zip of your DB while it is open. I added to the end of its code so it would open my back up system and I made a version of that for xyz.zip. Thus it then copies the zip all over the place with a date/time stamp. It jas two unbound textboxes for the path of the DB and the desiting of the zip file. I made then bound fields so it would store, or you could formula in the textbox etc.

    Foe those newer to making DBs where this is good is you are backing up the whole DB while it is open. Having things to export tables is great for data but useless for backing up what you have made, or are trying to make.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by gem1204
    ....I already know the best way to have done this would have been to link the presentation instead of embedding it – I don’t need anybody saying “I told you so”
    ... sorry can't help you there as you have forced my lips to be sealed(well fingers not to type
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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