Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Which format (2003 SP2)

    I've heard various arguments regarding the pros & cons for using either Access 2000 or 2003, including files sizes, network performance, corruption risks, etc.

    I'd like to know what the different caveats are for each, & what you people think is best.

    Cheers

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

    Re: Which format (2003 SP2)

    Access 2003 the program works fine, and has a number of improvements over 2000. But I'd stick to the 2000 database format.

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which format (2003 SP2)

    As a rider to HansV's post, make sure that you have at least SP1 installed. The vanilla Access2003 was rather buggy IMHO.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which format (2003 SP2)

    Thanks for the replies.

    Hans, could you give me your reasoning for please.

    Steve, good point (NB did you see the version I'm using? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45> )

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

    Re: Which format (2003 SP2)

    The Access 2002/2003 format creates much larger databases than the Access 2000 format, and is more prone to bloat.
    It also appears to be less stable, i.e. databases get corrupted more often.
    And you can't share the database with someone who still has Access 2000. If you use Access 2000 format, the database can be opened without conversion by anyone using Access 2000, 2002 or 2003.

    The only downside is that you can't create a .mde database from an Access 2000 format .mdb in Access 2003 (or Access 2002). You can only create a .mde from a .mdb in the native Access 2002/2003 format.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Which format (2003 SP2)

    From my own experience and other posts here, I'd suggest 2 things:

    The backend database should be in Access2000. There are apparently some bloating problems with 2003 than won't even be cured with compact/repair. Also, this allow A2000 machines to use it.

    The frontend should be consistent with whichever version a user has. I've just run into some problems with an A2003 machine trying to use an A2000 version of database. It all goes away if they use A2003 version. It is a bit of a hassle, but worth it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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