Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Dudley, Midlands, England
    Posts
    55
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Relative Performance (2K / XP)

    I have the opportunity at the moment to develop a new DB in either Access 2K or Access XP and I was wondering if there are any major differences performance-wise between the two versions. I've done a fair bit of development in 2K, plenty in 97, but I've not really seen XP so far; that said, if there were good performance reasons to use Access XP over 2K I would, otherwise I'll probably stick to 2K.

    In case it helps, the databases will have the front-end / back-end split (both parts in Access) and the DB will only be used at any one time by a single user, although there will be at least three separate and unconnected copies of the system each with their own data. Despite there initially only being three users, the system will have to run under Win 2K Professional, Win ME and Win XP! Don't ask!

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

    Re: Relative Performance (2K / XP)

    I don't think performance is significantly better in Access 2002 (if at all). Access 2002 has a few new features, such as pivot tables and pivot charts, and more XML support (ha ha); if you need those, go for XP, otherwise it's not really necessary, I think. The default database format in Access 2002 is still the Access 2000 format, so even if you stick with Access 2000 now, migrating to 2002 later on shouldn't be hard.

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

    Re: Relative Performance (2K / XP)

    Acc2002 also has some enhanced printer control capabilities that you might want to check-out.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Relative Performance (2K / XP)

    A2002 has the Printer object and PrtDevMode and PrtDevName objects, but they have limitations, so we still use API calls to manipulate printers in XP. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

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

    Re: Relative Performance (2K / XP)

    I've had little experience working with XP so far, as I only have one client that has it. Of course, it had it's own quirks I haven't figured out. Such as a report that would print in color if sent to the default printer, but would not print in color if that same printer was specified by name!

    I did have a way of handling printer selection by manipulating the default printer entry in Win.ini (it was clumsy, but it worked). But this apparently doesn't work under XP.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Relative Performance (2K / XP)

    The PrtDevNames method will at least give you the available printers, but we had developed code for earlier versions and we've found it's still more reliable than the new objects. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

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

    Re: Relative Performance (2K / XP)

    And given the mix of A2000 and A2002 machines that can be using the same database, you code solution is probably the best right now.
    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
  •