• Compatibility with 2000 (Access 97)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Compatibility with 2000 (Access 97)

    Author
    Topic
    WSLibbieL
    AskWoody Lounger
    June 19, 2003 at 6:37 pm #389321

    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.
    brainwash

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      June 19, 2003 at 6:45 pm #687007

      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.

      Reply | Quote
      • WSLibbieL
        AskWoody Lounger
        June 19, 2003 at 6:54 pm #687009

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

        Reply | Quote
      • WSBat17
        AskWoody Lounger
        June 20, 2003 at 5:00 am #687125

        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

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          June 20, 2003 at 6:01 am #687134

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

          Reply | Quote
        • WScharlotte
          AskWoody Lounger
          June 20, 2003 at 11:26 am #687163

          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.

          Reply | Quote
          • WSBat17
            AskWoody Lounger
            June 20, 2003 at 12:33 pm #687172

            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

            Reply | Quote
            • WBell
              AskWoody_MVP
              June 20, 2003 at 12:58 pm #687175

              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! sad

              Reply | Quote
            • WSdazednconfused
              AskWoody Lounger
              June 20, 2003 at 1:10 pm #687176

              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

              Reply | Quote
            • WSBat17
              AskWoody Lounger
              June 20, 2003 at 2:19 pm #687188

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

              Reply | Quote
    Viewing 0 reply threads
    Reply To: Compatibility with 2000 (Access 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.