Welcome to SPN

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

Sign Up Now!

CAN I ACCESS DATABASES THAT WERE MADE ON NEWER VERSIONS OF ACCESS.

Discussion in 'Information Technology' started by ADAM__, Jul 28, 2006.

  1. ADAM__

    ADAM__
    Expand Collapse
    Guest

    I HAVE A DATABASE THAT WAS CREATED ON ACCESS 2003 BUT MY LAPTOP ONLY HAS
    ACCESS 2000. CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003

    tHANKS aDAM
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Save your database to the default Access 2000 format.:

    Tools ... Database Utilities ... Convert Database
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "ADAM__" <ADAM__@discussions.microsoft.com> wrote in message
    news:266912BF-1045-44C2-B3DD-5B8F59A00414@microsoft.com...
    >I HAVE A DATABASE THAT WAS CREATED ON ACCESS 2003 BUT MY LAPTOP ONLY HAS
    > ACCESS 2000. CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS
    > 2003
    >
    > tHANKS aDAM
     
  4. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Adam.

    > CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003


    If and only if the file's database format is Access 2000 database format,
    you can open it with Access 2000. Otherwise, you can link to the tables in
    an Access 2002-2003 database formatted file from another Access 2000 database
    on your laptop. If you have to actually open the file, and the file is in
    Access 2002-2003 database format, and is not an MDE file, then you'll need to
    have someone with Access 2002 or Access 2003 convert the file to Access 2000
    database format for you.

    BTW, typing in all caps is considered shouting to Internet readers, which is
    considered rude by many newsgroup readers.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.


    "ADAM__" wrote:

    > I HAVE A DATABASE THAT WAS CREATED ON ACCESS 2003 BUT MY LAPTOP ONLY HAS
    > ACCESS 2000. CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003
    >
    > tHANKS aDAM
     
  5. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    Camaro, you cannot link to an A2002-2003 database from A2K. A2K cannot
    recognize newer formats (Access is not alone in this failing - ALL
    applications suffer from it). When A2K was written, the programmers would
    have had to be prescient to have known what the file format would be several
    years later. So, without exception, if the format of an application's files
    changes from one version to another, the older version will not be able to
    read the newer version's files.

    However, Microsoft is making an effort to get around this problem with Word
    and Excel. I believe they have a tool which you can download which will
    allow older versions of Word and Excel to read the new XML file formats.
    This will not extend to Access though.

    "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote in
    message news:9C245FFD-1825-466F-A686-31D17C1150AF@microsoft.com...
    > Hi, Adam.
    >
    >> CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003

    >
    > If and only if the file's database format is Access 2000 database format,
    > you can open it with Access 2000. Otherwise, you can link to the tables
    > in
    > an Access 2002-2003 database formatted file from another Access 2000
    > database
    > on your laptop. If you have to actually open the file, and the file is in
    > Access 2002-2003 database format, and is not an MDE file, then you'll need
    > to
    > have someone with Access 2002 or Access 2003 convert the file to Access
    > 2000
    > database format for you.
    >
    > BTW, typing in all caps is considered shouting to Internet readers, which
    > is
    > considered rude by many newsgroup readers.
    >
    > HTH.
    > Gunny
    >
    > See http://www.QBuilt.com for all your database needs.
    > See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    > info.
    >
    >
    > "ADAM__" wrote:
    >
    >> I HAVE A DATABASE THAT WAS CREATED ON ACCESS 2003 BUT MY LAPTOP ONLY HAS
    >> ACCESS 2000. CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS
    >> 2003
    >>
    >> tHANKS aDAM
     
  6. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Pat.

    Thanks for catching my typo.

    Gunny


    "Pat Hartman(MVP)" <patsky@NoSpam.optonline.net> wrote in message
    news:utHxsBVmGHA.856@TK2MSFTNGP03.phx.gbl...
    > Camaro, you cannot link to an A2002-2003 database from A2K. A2K cannot
    > recognize newer formats (Access is not alone in this failing - ALL
    > applications suffer from it). When A2K was written, the programmers would
    > have had to be prescient to have known what the file format would be
    > several years later. So, without exception, if the format of an
    > application's files changes from one version to another, the older version
    > will not be able to read the newer version's files.
    >
    > However, Microsoft is making an effort to get around this problem with
    > Word and Excel. I believe they have a tool which you can download which
    > will allow older versions of Word and Excel to read the new XML file
    > formats. This will not extend to Access though.
    >
    > "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote
    > in message news:9C245FFD-1825-466F-A686-31D17C1150AF@microsoft.com...
    >> Hi, Adam.
    >>
    >>> CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003

    >>
    >> If and only if the file's database format is Access 2000 database format,
    >> you can open it with Access 2000. Otherwise, you can link to the tables
    >> in
    >> an Access 2002-2003 database formatted file from another Access 2000
    >> database
    >> on your laptop. If you have to actually open the file, and the file is
    >> in
    >> Access 2002-2003 database format, and is not an MDE file, then you'll
    >> need to
    >> have someone with Access 2002 or Access 2003 convert the file to Access
    >> 2000
    >> database format for you.
    >>
    >> BTW, typing in all caps is considered shouting to Internet readers, which
    >> is
    >> considered rude by many newsgroup readers.
    >>
    >> HTH.
    >> Gunny
    >>
    >> See http://www.QBuilt.com for all your database needs.
    >> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    >> info.
    >>
    >>
    >> "ADAM__" wrote:
    >>
    >>> I HAVE A DATABASE THAT WAS CREATED ON ACCESS 2003 BUT MY LAPTOP ONLY HAS
    >>> ACCESS 2000. CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS
    >>> 2003
    >>>
    >>> tHANKS aDAM

    >
    >
     

Share This Page