Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Location
    California
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is Access compatible with Access 2k? (Access 2k)

    I understand from various sources that Access 97 is not compatible with Access 2000? We have a very large database in 2000. We have a client who only has 97. Of course, tell client to upgrade. Just want to confirm.

    thanks.

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

    Re: Is Access compatible with Access 2k? (Access 2k)

    Correct. Either he converts to Access 2000 or you convert the Access 2000 database back to Access 97 (which may very well not be practical).

    If you try to open an Access 2000 database in Access 97 you'll get an "Unrecognized database format" error message.

  3. #3
    Star Lounger
    Join Date
    Oct 2001
    Location
    California
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Access compatible with Access 2k? (Access 2k)

    Thanks for your response. Thanks for the confirmation. Have a great day!

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

    Re: Is Access compatible with Access 2k? (Access 2k)

    To be completely correct, you should note that you can downgrade a A2K database to A97 - there is a tool in A2K that will do that for you. On the other hand it can be really tedious to have to downgrade the database every time you make a design change. AND there are some things (like ADO for example) that don't exist in A97. So the answer to the client is UPGRADE! Hope this helps.
    Wendell

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

    Re: Is Access compatible with Access 2k? (Access 2k)

    Wendell,

    You can use ADO with Access 97, but you don't really get all the benefits of the built-in compatibility that A2k has with ADO. I can't remember having tried it myself, but I've been assured by those who should definitely know that it can, in fact, be done.
    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
  •