Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    version trouble (xp & 97)

    I created a database in Access XP, which will be further manipulated in '97. We would like to use this database on the computer containing XP and those with '97. Is it possible to convert the XP database to '97 and use it that way? Any ideas. Thanks!

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: version trouble (xp & 97)

    You can use Convert Database under Database Utilities to convert the database back to Access 97. However, you may not be able to share the same database between the two versions of Access at the same time. There is some documentation in the Access help files about this.

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

    Re: version trouble (xp & 97)

    If you convert the database back to 97 (that option still exists in Access 2002), it will generally work fine as long as you haven't used any functionality new in 2000 or 2002. Examples would be ADO, conditional formatting, etc. However 2002 will prompt you about converting the database each time you open it, and you will not be able to make any design changes (queries, forms, reports) in the 97 version unless you convert it back to 2000 or 2002 format. Not a totally happy situation, but that's the way it is! <img src=/S/ouch.gif border=0 alt=ouch width=15 height=15>
    Wendell

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

    Re: version trouble (xp & 97)

    Your performance will also suffer running it as a 97 database under XP, since there's a lot of translating that goes on between the versions. Since XP requires a more robust machine, though, you might not notice the penalty too much on those machines.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Apr 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: version trouble (xp & 97)

    Thank you all!-Margaret

Posting Permissions

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