Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Wellfleet, Massachusetts, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compatibility with 2000 (Access 97)

    I need to share Access files with someone who uses Access 2000. She said that she can not open my Access 97 file without first making a copy of it and using that copy to work with. She spoke to someone at Microsoft who gave her this info. Does this make sense???
    Thanks for your help with this puzzling question.
    <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15>
    LibbieL

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

    Re: Compatibility with 2000 (Access 97)

    If someone with Access 2000 opens an Access 97 database, she is presented with two options:
    1. If she needs to be able to modify the design of forms etc., she must convert the database to Access 2000 format. The Access 2000 database must be saved under a different name. Perhaps this was meant by making a copy - the original Access 97 database is left untouched.
    2. If she only needs to use the database, she can open the database in Access 97 format; in that case, she won't be able to modify the design of forms etc., but she can enter and edit data, view reports etc.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Wellfleet, Massachusetts, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compatibility with 2000 (Access 97)

    Thank you, Hans. You explained the situation quite clearly and so quickly!. Now I understand.
    Libbie
    LibbieL

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compatibility with 2000 (Access 97)

    Hans
    Do you know if there is any difference in efficency between converting or not converting a A97 frontend to A2000 when working with a A97 backend?

    Peter

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

    Re: Compatibility with 2000 (Access 97)

    I don't know, I have never measured performance differences.

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

    Re: Compatibility with 2000 (Access 97)

    Access 2000 front ends are slow when linked to 97 backends, if that answers your question. If you're talking about simply opening the 97 front end in 2000 rather than converting it, it will still be slow.
    Charlotte

  7. #7
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compatibility with 2000 (Access 97)

    I had thought that the company standard was for A97 but it turns out that a few managers have A2k. I have produced a Database that will be used factory wide but only 2 people will have write privileges in the DB, using user-level security.

    I have not had a chance to test the DB using A2k but if there is no real speed advantage in conversion then I will try to just open the DB in A2k which will save me problems when I have to change the design yet again!

    Peter

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

    Re: Compatibility with 2000 (Access 97)

    You want to be sure to split it if you haven't already - otherwise one of your managers will convert it and then only the folks with 2000 will be able to open it! <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    Wendell

  9. #9
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compatibility with 2000 (Access 97)

    The company I work for recently upgraded from 97 to 2000, until all the users were upgraded the systems were left as 97, once the site wide upgrade was completed I converted the databases to 2k.

    The only problems I had reported was a drop off in performance while using the 97 system in 2k, once the conversion was complete the systems appeared to run more quickly and definitely take up less server space than they did before.

    I did quickly set up the basic Microsoft security, to stop users from converting the systems accidentally, but this was not time consuming.

    Hope this is useful.

    Ian

  10. #10
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compatibility with 2000 (Access 97)

    I have the DB split and secured, the managers get the form it opens on and that

Posting Permissions

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