Converting Access2003 to 2007 Problem

Discussion in 'OT Technology' started by GuiltySparc, Aug 19, 2009.

  1. GuiltySparc

    GuiltySparc OT Supporter

    Joined:
    Apr 14, 2004
    Messages:
    12,070
    Likes Received:
    0
    Location:
    Maryland
    My company is going to switch to office 2007 this fall and i'm doing some of the pre-switch testing. When i convert an access 2003 database to 2007, none of the sql commands in VBA work. Any idea as to whats going on there?

    Thanks in advance!
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Yes, you're not being specific enought about which code worked and now why it doesn't work (ie the transformed code if there is any).
     
  3. GuiltySparc

    GuiltySparc OT Supporter

    Joined:
    Apr 14, 2004
    Messages:
    12,070
    Likes Received:
    0
    Location:
    Maryland
    I'll grab a few samples and post. Thanks!
     
  4. GuiltySparc

    GuiltySparc OT Supporter

    Joined:
    Apr 14, 2004
    Messages:
    12,070
    Likes Received:
    0
    Location:
    Maryland
    oh of course the testing computer doesnt have outlook on it so i cant get the coworker down there to email me code to post.

    At any rate, one of the ones that i remember her showing me is that we get a type mismatch error on rs.edit (where rs is the name of a recordset). I'll go back to the lab and jot down some more notes.
     
  5. GuiltySparc

    GuiltySparc OT Supporter

    Joined:
    Apr 14, 2004
    Messages:
    12,070
    Likes Received:
    0
    Location:
    Maryland
    something like this...

    ...brings back a type mismatch error.
     
  6. GuiltySparc

    GuiltySparc OT Supporter

    Joined:
    Apr 14, 2004
    Messages:
    12,070
    Likes Received:
    0
    Location:
    Maryland
    for those interested, we got it working by disabling a few reference libraries.
     

Share This Page