Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mundelein, Illinois, USA
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Compatability (Office XP - Office 2K)

    Does anyone know what the file compatability is between Access used in Office 2K and Office XP? I have people on new and older machines with these two versions of Office that need to trade files.

    (Also, how about the rest of the Office Suite?)

    Thanks
    Thanks,

    C DeWitt

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: File Compatability (Office XP - Office 2K)

    By default, Access2002 uses Access2000 database format, so you can read/write into the same database from both Access2000 and 2002. Of course, if your database uses newer Access2002 features, an Access2000 user won't be able to use them (I don't know what would happen, an error of some sort I guess). Access2002 can also write databases with its own Access2002 format, which of course an Access2000 database can't read. I believe the other parts of OfficeXP are also compatible.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: File Compatability (Office XP - Office 2K)

    Mark's comments are correct, but one caution is in order. Be sure you do development work on database objects in Access 2000. I've had at least three separate instances where an Access 2000 database developed on Access 2002 refused to work correctly on some Access 2000 workstations. Importing all objects into an Access 2000 PC in a new database seemed to solve most of the problems, but in one case I had to actually convert the database to Access97 and then back to Access 2000 to get it to behave. That said, I have been developing in 2002 for over a year now, and 2002 seems quite stable. Hope this is useful.
    Wendell

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: File Compatability (Office XP - Office 2K)

    >>, but one caution is in order. <<

    That's good to know. I haven't used Access2002 directly. I have a client who has it, however, and I maintain the database (in Access2000) on my machine. I then export any changed objects to an Update database and xmit to client. He opens the UPdate database which copies the changed/new objects into his copy of master database (deleting prior version of objects as necessary). So far this has worked without incident. His master database is in Access2000 format, but I suppose I could use this same method to update his database even if it was in Access2002 format.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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