Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 97 vs 02 (Access 97)

    we're scheduled to upgrade from Access 97 to Access 2002 within 6 mos - I haven't set up any dbases yet and just heard a rumor that any dbases in 97 would not be usable once we upgrade - does anyone know if this is true? am I better off waiting to set up dbases until after the upgrade?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 97 vs 02 (Access 97)

    Access 2002 (XP) uses a different file format from Access 97, so if you set up databases now, you'll have to convert them. Most things should work OK after conversion.

    The native data object model in Access 97 is DAO (Data Access Objects); in Access 2000 and XP it's ADO (ActiveX Data Objects). They are quite different (although there are similarities). Although Access 2000 and XP support DAO, it might be better to wait and start from scratch using ADO in XP if you are going to create lots of code that works with recordsets etc.

    Here is a link to a previous thread on converting - it's mostly about converting from 97 to 2000, but Access 2000 and XP aren't all that different: <post#=169209>post 169209</post#>.

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

    Re: Access 97 vs 02 (Access 97)

    If by that you mean that you couldn't open the upgraded databases with Access 97, that is true, and it has been true for every version of Access since the beginning. Later versions can open earlier version files but not the other way around. When you say you haven't set up any databases, does that mean that you don't have any applications to convert? In that case, there is no issue. If you do have existing 97 databases, you can convert them to a later version of Access and still use any code as long as you have a reference set to the DAO object library and you uncheck the ADO reference. I agree with Hans that you might be better off learning ADO from the start if you don't already have a lot of DAO code to maintain.
    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
  •