Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Difference between 97 and 2000

Discussion in 'Information Technology' started by Michael, Nov 4, 2005.

  1. Michael

    Michael
    Expand Collapse
    Guest

    I am teaching a small Access class in a few weeks. The students have Access
    97 and I have Access 2000. For the students, I am converting the Access 2000
    practice files to Access 97. I understand that the character set between the
    two versions are different, but from the screen shots of Access 97 I have
    seen on the web (I don't have a copy) look very similar to Access 2000. The
    class will be mostly about queries, forms, and reports.

    For someone who knows both versions well, will I be able to teach this class
    without any problems if I convert the 2000 files to 97 files? Are the
    features between Access 97 and 2000 pretty much the same?
     
  2. Loading...

    Similar Threads Forum Date
    Difference between us and the Gurus? Sikh Sikhi Sikhism Dec 25, 2014
    Hinduism Difference between Sikhi and Bhakti Hinduism Interfaith Dialogues Mar 5, 2014
    Islam What Is Difference Between Sikhism And Islam - Dr. Zakir naik Interfaith Dialogues Jun 16, 2013
    1984 Vast differences between Jallianwala Bagh and 1984 Bluestar History of Sikhism Aug 1, 2012
    What is the difference between a knife and kirpan? Questions and Answers Jul 3, 2012

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    For the most part, they're the same. Since you have Access 2000, take a look
    at the "What's New" in the help file.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Michael" <ibvalentine@hotmail.com> wrote in message
    news:NVvaf.3586$Jo3.473@tornado.socal.rr.com...
    >I am teaching a small Access class in a few weeks. The students have Access
    >97 and I have Access 2000. For the students, I am converting the Access
    >2000 practice files to Access 97. I understand that the character set
    >between the two versions are different, but from the screen shots of Access
    >97 I have seen on the web (I don't have a copy) look very similar to Access
    >2000. The class will be mostly about queries, forms, and reports.
    >
    > For someone who knows both versions well, will I be able to teach this
    > class without any problems if I convert the 2000 files to 97 files? Are
    > the features between Access 97 and 2000 pretty much the same?
    >
     
  4. RioDeSmoke

    RioDeSmoke
    Expand Collapse
    Guest

    Doug,

    I am very familiar with both versions. I can name several differences.
    - the biggest difference in converting the db from 2000 to 97 is that 2000
    uses ADO connections as a deault and 97 uses DAO. If you do a search on the
    web you can find the code differences. It potentially could give you a hard
    time converting backwards.
    - Another good thing to mention (for them to upgrade) is the advantage of
    ..adp and SQL Server.
    - Other small differences like "Link Table Manager" is now under Utilities
    rather than "Add-Ins"
    - defaults such as importing files with a .txt and not excepting user
    defines extensions

    The building os q,f,r should be very similiar, but how you going about
    getting the data could be drastically different. Hope the class goes well.

    "Douglas J. Steele" wrote:

    > For the most part, they're the same. Since you have Access 2000, take a look
    > at the "What's New" in the help file.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Michael" <ibvalentine@hotmail.com> wrote in message
    > news:NVvaf.3586$Jo3.473@tornado.socal.rr.com...
    > >I am teaching a small Access class in a few weeks. The students have Access
    > >97 and I have Access 2000. For the students, I am converting the Access
    > >2000 practice files to Access 97. I understand that the character set
    > >between the two versions are different, but from the screen shots of Access
    > >97 I have seen on the web (I don't have a copy) look very similar to Access
    > >2000. The class will be mostly about queries, forms, and reports.
    > >
    > > For someone who knows both versions well, will I be able to teach this
    > > class without any problems if I convert the 2000 files to 97 files? Are
    > > the features between Access 97 and 2000 pretty much the same?
    > >

    >
    >
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Another difference, not previously mentioned, is Conditional Formatting
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "RioDeSmoke" <RioDeSmoke@discussions.microsoft.com> wrote in message
    news:0D050B0F-4551-48E0-B7DC-820FD783C19A@microsoft.com...
    > Doug,
    >
    > I am very familiar with both versions. I can name several differences.
    > - the biggest difference in converting the db from 2000 to 97 is that 2000
    > uses ADO connections as a deault and 97 uses DAO. If you do a search on

    the
    > web you can find the code differences. It potentially could give you a

    hard
    > time converting backwards.
    > - Another good thing to mention (for them to upgrade) is the advantage of
    > .adp and SQL Server.
    > - Other small differences like "Link Table Manager" is now under Utilities
    > rather than "Add-Ins"
    > - defaults such as importing files with a .txt and not excepting user
    > defines extensions
    >
    > The building os q,f,r should be very similiar, but how you going about
    > getting the data could be drastically different. Hope the class goes

    well.
    >
    > "Douglas J. Steele" wrote:
    >
    > > For the most part, they're the same. Since you have Access 2000, take a

    look
    > > at the "What's New" in the help file.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > >
    > > "Michael" <ibvalentine@hotmail.com> wrote in message
    > > news:NVvaf.3586$Jo3.473@tornado.socal.rr.com...
    > > >I am teaching a small Access class in a few weeks. The students have

    Access
    > > >97 and I have Access 2000. For the students, I am converting the Access
    > > >2000 practice files to Access 97. I understand that the character set
    > > >between the two versions are different, but from the screen shots of

    Access
    > > >97 I have seen on the web (I don't have a copy) look very similar to

    Access
    > > >2000. The class will be mostly about queries, forms, and reports.
    > > >
    > > > For someone who knows both versions well, will I be able to teach this
    > > > class without any problems if I convert the 2000 files to 97 files?

    Are
    > > > the features between Access 97 and 2000 pretty much the same?
    > > >

    > >
    > >
    > >
     

Share This Page