Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrading Office 97 to 2000 (Office 97 to 2000)

    Hello there,

    I am looking for information on issues to consider when upgrading from Office 97 to 2000. Is there any doco out there that addresses these issues? I am particularly interested in converting Access databases, Word documents and templates. However, I would really like information on the whole suite of products.

    Looking forward to hearing from you. Regards, Jocelyn

  2. #2
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading Office 97 to 2000 (Office 97 to 2000)

    Did you realize you posted this in the .Net forum? <img src=/S/doh.gif border=0 alt=doh width=15 height=15> It should be in either the 'general office' forum or the Access forum since you're more interested in that product.

    I can't answer your question specifically but it sounds like you need info on how converting Office 97 files to Office 2k files will change things (for better or worse). The answer as usual is "it depends." Since the older files can't and don't have any features found only in the newer version, there's no mess ups. I only work work Word and Excel so don't know any evils about upgrading for Access. Since Office 2002 (XP) is the latest rendition of Office you're only upgrading one version so you'll probably be ok. If all else fails, just try it! Just make a backup of your old Office 97 access database and open it (or import if needed) into Access 2000. Then test every table and and see if it still works.You'll never get as full a list of product differences from MS as you will by figuring it out yourself (they're not going to tell you *everything*).

    If you're also inquiring about VBA and not just the files themselves then that's another issue as there are always incompatibilities with upgrading and they're never documented (you have to stumble across them yourself).

    Deb

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading Office 97 to 2000 (Office 97 to 2000)

    Thanks Deb,

    Ooops I didn't realise that one. Thanks again and I shall post it at the General Office forum.

    Regards,
    Jocelyn

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

    Re: Upgrading Office 97 to 2000 (Office 97 to 2000)

    Word, Excel and PowerPoint should cause relatively few problems. Each of these applications has new features (and annoyances) in the 2000 version, but the file format has not changed, so existing documents, spreadsheets and presentations can be used without conversion.

    If there is going to be a period of transition when some users have already gone over to Office 2000 while others are still using Office 97, keep it as short as possible. Office 2000 users should avoid using the new features in documents that will be shared with Office 97 users.

    The file format for Access has changed. If you try to open an Access 97 database in Access 2000, you get two options:
    <UL><LI>Open as Access 97 database - you won't be able to change the design of forms etc.
    <LI>Convert to Access 2000 database - after conversion, the database can't be opened by Access 97 users. However, it is possible to convert back (Tools/Database Utilities/Convert Database/To Prior Version).[/list]Some people report problems with databases converted by Access; they recommend creating a new blank database and importing all objects from the Access 97 database into it.

    The default data model in Access 97 was DAO (Data Access Objects). This still works in Access 2000, but the default data model for new databases is ADO (ActiveX Data Objects). The models have some objects with the same name, such as Recordset and Field. This can cause confusion in VBA code. To avoid this, prefix such objects with either DAO. or ADODB. when declaring them. For example:

    Dim rst As DAO.Recordset
    Dim fld As DAO.Field

    If you have databases with a Frontend/Backend setup, you can give the Office 2000 users an Access 2000 frontend that connects to the existing Access 97 backend. This way, both groups of users can use the same backend during the transition period (again, keep it as short as possible). Performance won't be stellar, though.

    An important change that developers should be aware of is that you should have exclusive access to a database when you want to modify the design of forms etc. It is not possible to do so anymore while others users have the database open. Some people find this annoying, but it was a cause of problems and database corruption in previous versions.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading Office 97 to 2000 (Office 97 to 2000)

    In additon, macros written in Office 97 might not work as expected in Office 2000.

    For example, Office 2000 uses SDI model, but Office 97 uses MDI model. Changing macros to accommodate the move to SDI is complex, see http://www.standards.com/OhMyWord/VBACodeSnippets.html for an example of the issues involved.

  6. #6
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading Office 97 to 2000 (Office 97 to 2000)

    Thankyou so much for your response HansV, I am most grateful for your efforts. I am particularly interested in the Access conversion issues and will try each of your suggestions.

    Kind regards,
    Jocelyn

  7. #7
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrading Office 97 to 2000 (Office 97 to 2000)

    Thanks Howard I will also look into these issues as well.

    Cheers,
    Jocelyn

Posting Permissions

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