Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Save A2k Project as A97? (A2k (9.0.3821) SR-1)

    Save A2k Project as A97?

    A2k (9.0.3821) SR-1

    If I save an A2k project, as A97 will I get errors if I

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

    Re: Save A2k Project as A97? (A2k (9.0.3821) SR-1)

    I don't think Access will even let you try to do that - I must confess I havn't tried however. It is essentially an upsizing effort in reverse, and the 2000 upsizing tools are rather limited. (This is predicated on the assumption that since you used the word Project that you are dealing with an ADP file, not an MDB file.) It is possible to get the data converted by simply importing the tables into an MDB file, but stored procedures, forms and reports are VERY different. Sounds like a significant challenge to me - big enough to consider converting the users to 2000 as a cheaper alternative.
    Wendell

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

    Re: Save A2k Project as A97? (A2k (9.0.3821) SR-1)

    A2k will let you convert to the earlier version even if you use features that aren't supported. When you open the 97 version and try to compile it, you'll discover all the things that aren't supported. Aside from having to be careful about that, I haven't had any problems converting from A2k to 97.
    Charlotte

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save A2k Project as A97? (A2k (9.0.3821) SR-1)

    Hi Wendell

    Sorry I meant db.

    Charlotte is right.

    Just wanted to know where I should expect the land mine?

    1. Save a2k.mdb as a97.mdb

    or

    2. Complie a97.mdb from above.

    Thanks All

    John

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

    Re: Save A2k Project as A97? (A2k (9.0.3821) SR-1)

    Ok - that works reasonably well - in fact you may find some interesting changes when you do 97 to 2000 to 97 to 2000. For what ever reason, it will often make the 97 and 2000 databases smaller on the second pass, even though the original 97 DB was compacted before you start. Unless you've done lots of things to the 2000 database that are 2000 only features, it should go fairly well.
    Wendell

Posting Permissions

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