Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 97 to Access 2000 Conversion (Access 97)

    Hello all: My company is upgrading from MS Office 97 to MS Office 2000 (Access included) in a couple of weeks. What problems will I encounter with my split databases when I try to convert them to Access 2000? Any and all suggestions are welcome. TIA.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 to Access 2000 Conversion (Access 97)

    I found the information I was looking for on, of all places, MS KB site, Q237313 which has a conversion white paper that can be downloaded.

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

    Re: Access 97 to Access 2000 Conversion (Access 97)

    >>I found the information I was looking for on, of all places, MS KB site<<

    Don't be so surprised. What makes some of us "experts" is that we know how to lookup things in the MSKB! Now everyone will know!<g>
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access 97 to Access 2000 Conversion (Access 97)

    I don't mean to dismiss the information in the White Paper - it is quite valuable. However it was written in 1999 and there have been some additional discoveries. For one thing, if you have a split front-end/back-end database, if possible convert both at the same time. We recently converted several dozen Access 97 apps to Access 2K and had to leave the back-end in Access 97 for a while. We experienced a significant performance problem during that time, and ultimately some corruption that caused us to loose some data records in the back-end.

    Also, if you are using any of the Windows Common Controls, be sure and update the references to the version that comes with Office 2K (mscomctl.ocx). Otherwise the behavior of things like the treeview and image controls seems flakey. Also note that there are several versions of mscomctl.ocx floating around - make sure you and all of your users are on the same version.

    Hope our experience is of some use to you.
    Wendell

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 to Access 2000 Conversion (Access 97)

    Wendell: Thanks for the insights. I appreciate your response and I think I will take your advice to convert front-end/back-end at the same time.

Posting Permissions

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