Results 1 to 7 of 7
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Database Format Choice (XP SR2)

    In upgrading a client (across the board) from Access97 to Access2002 would you choose the 2000 or the 2002 format?
    Wendell

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

    Re: Database Format Choice (XP SR2)

    If this is strictly for internal use with the client, I would choose Access 2002 format. One advantage is that you can create .MDE databases.

    But if there is even a remote chance that the database would have to be distributed externally too, I would choose Access 2000 format. The Office 2000 installed base is still huge, and since Access 2000 format can be opened and edited without converting in Access 2000, 2002 and 2003, you cover the majority with the 2000 format.

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

    Re: Database Format Choice (XP SR2)

    We use both formats, but Access 2002 has a built in bloat problem due to the existence of the MSysAccessStorage table, which doesn't exist in 2000 format. Since the only way to recover from it is to import all the objects into a new database, I'd suggest 2000 format unless you absolutely require 2002 (like for MDEs). We mix the formats, FE in 2002 and BE in 2000, but it isn't an approach I would really recommend, since you continually have to recall which format something *should* be in.
    Charlotte

  4. #4
    Star Lounger
    Join Date
    Jun 2001
    Location
    Christchurch, New Zealand
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Format Choice (XP SR2)

    I find your access 2000 v 2002 interesting as it applies in sort to a project that I am working on at the moment.

    I have just been testing 2000 and 2002 runtime installations. I have found the 2002 runtime much easier to work with (very new to runtime) and have tested the A2000 db running on the 2002 runtime. It appears to be fine and operates ok.

    Would it be ok to distribute a 2002 package with a 2000 db inside?

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

    Re: Database Format Choice (XP SR2)

    By all means use the XP runtime. We're talking about the file format rather than the runtime version and packaging wizard. Our runtime packages include both 2002 and 2000 format files. It only gets tricky if you're using MDEs, which have to be in the format of the Office version.
    Charlotte

  6. #6
    Star Lounger
    Join Date
    Jun 2001
    Location
    Christchurch, New Zealand
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Format Choice (XP SR2)

    I tested this using 2000 and 2002 mde's using the 2002 runtime and both db's worked without error. The db will be mde so I take it that I should be very careful with using a 2000 mde version on an 2002 runtime platform then? Is there anything that I really need to watch out for??

    Appreciate the advice.
    Thanks
    Tony

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

    Re: Database Format Choice (XP SR2)

    No, the problem with MDE's is that you can only make an Access 2000 format MDE with Access 2000, and an Access 2002 format MDE only with Access 2002. Even though Access 2002 can create Access 2000 databases and work with them without converting, it can't create an Access 2000 format MDE.

    And you have to be very careful about non-standard references in VBA.

Posting Permissions

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