Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Watford, Hertfordshire, England
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting 97 to 2000 (97 to 2000)

    We are about to upgrade to Access 2000. We have lots of databases in existance written in 97. What problems should I be aware of and what is the best way to upgrade these old databases?

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

    Re: Converting 97 to 2000 (97 to 2000)

    Here are a few remarks. There is much more, of course. Loungers with more experience in this will no doubt chime in.

    (1) Access 2000 uses ADO as default object model, while Access 97 used DAO. You can still use DAO in Access 2000. I would stick with it for the moment. Later on, when you've converted your databases successfully, you can start playing with ADO.
    It might be a good idea to prefix DAO objects in declarations in your code with "DAO." to avoid confusion with ADO objects with the same name. For example:
    Dim dbs As DAO.Database
    Dim rst As DAO.Recordset

    (2) Access 97 has a "formatted message box" feature: MsgBox "Error@Something went wrong.@Contact the help desk." displays as

    <font color=blue>Error

    Something went wrong.

    Contact the help desk.</font color=blue>

    This doesn't work any more in Access 2000. It'll just display the @'s. So either replace the @'s by " & vbCrLf & " or use a workaround. If you do a search for "formatted msgbox" or something similar, you'll find ways to display a formatted message box in Access 2000. (Opinions on the usefulness vary)

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Location
    Watford, Hertfordshire, England
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    Thanks for this, any more help from anyone else greatly appreciated. I don't care how "Basic" the steps or information, in fact, it is probably what I need....

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    Almost always the builtin conversion works fairly well. Open an Access 97 database in Access 2000 and it will prompt you whether you want to convert it. If you tell it to convert it, it will turn it into an Access 2000 database for you, with all the references in the correct order (if you create an Access 2000 database from scratch and want to continue using DAO, you either need to put the references in the correct order or use DAO. in all the appropriate places in your code).

    Make sure before converting an Access 97 database that it compiles OK. You may still run into the situation where the database won't convert without errors, but I've only run into that with one of my databases. If the database converts without errors I (so far) haven't had any problems with the converted databases.

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    There are numerous MS Knowledge Base (MSKB) articles re: Conversion to Access 2000 that you may want to check out. Some deal with specific conversion issues, some are more general in nature. I'd take a look at these:

    ACC2000: Where to Find Conversion Information for Microsoft Access 2000

    ACC2000: Conversion White Paper Available in Download Center

    The first article listed includes links to some of the other articles that deal with specific conversion issues. The second has link to download the conversion "white paper", a Word document with detailed information that you may find useful.

    By the way, isn't today the big day to commemorate the King? <img src=/S/king.gif border=0 alt=king width=21 height=22> Unless the "Elvis" in your name refers to Elvis Costello....

    HTH

  6. #6
    New Lounger
    Join Date
    Aug 2002
    Location
    Watford, Hertfordshire, England
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    Thanks for this, appreciated.

  7. #7
    New Lounger
    Join Date
    Aug 2002
    Location
    Watford, Hertfordshire, England
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    Hey Mark,

    Excellent, hip swivelling weekend and then back to some great help. What more could a fan want? And Elvis Costello might be OK, but should always be referred to by the full name - because there is only one "Elvis". The King live on - in my front room.

    By the way, I heard you were safe from Polar Bears - they don't eat penguins - (can't get the wrappers off).

    Cheers

  8. #8
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    Somewhere there is also a post from Charlotte who said you should decompile and then re-compile your Access 97 database, compact and repair it, and then do the conversion. BTW, de-compile is a command line switch, e.g. at the command prompt type msaccess.exe /decompile yourdatabase.mdb.
    Rock on,
    Gwenda

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

    Re: Converting 97 to 2000 (97 to 2000)

    There's a post on decompile here, but I'm not sure what other threads it might have been referenced in.
    Charlotte

  10. #10
    New Lounger
    Join Date
    Aug 2002
    Location
    Watford, Hertfordshire, England
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting 97 to 2000 (97 to 2000)

    Thank you. I have now got plenty of ammunition to arm our database chaps with. Chocks away people - We're going in....

Posting Permissions

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