Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Office 2000 and sr 1a (2k)

    I've read a lot lately (including inWOW) that the best version of Office is 2k with sr1a. I have 2k and it works fine. I use all the programmes fairly frequently - particularly Access and Word and have had no problems with it at all. I'm not inclined to fix it when it is not broken but is there any real advantage to sr1a? Should I go for it and if so can any one tell me why?
    Thanks.
    Peter

  2. #2
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office 2000 and sr 1a (2k)

    It is really depends of how do you use Office -- SR1 is a collection of minor fixes and security patches. For details, see <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-US;q245021>List of Fixed Problems in Microsoft Office 2000 Service Release 1/1a</A>

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

    Re: Office 2000 and sr 1a (2k)

    If you use Access heavily and especially if you change the design and otherwise modify the database structures, definitely apply SR1a. There are a couple of bugs in the vanilla 2k version that will drive you nuts otherwise, and there isn't really any way to program around them. One of these is the fact that when you append a value to an autonumber field, it doesn't reset the next value of the autonumber. Instead, you wind up trying to add new records to a table and getting duplicate key or index errors until you finally manage to reach the end of the appended values.
    Charlotte

  4. #4
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office 2000 and sr 1a (2k)

    Charlotte,

    I know I should ask this in Access, but as you've brought it up here.....

    With Access 9.0.4402 SR1, when I rename a query I have to rebuild any dependant queries as the name isn't changed in them. I have all 3 name autocorrect options turned on. Would this be solved by upgrading to sr1a? Or should I shuffle off to Access and delve deeper into the problem there?

  5. #5
    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: Office 2000 and sr 1a (2k)

    If you're using Name Autocorrect in Access2K you should definitely apply SR1a.
    Name Autocorrect does several wierd things which SR1a fixes.
    (Try setting a report to landscape and keeping it as landscape!?) <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office 2000 and sr 1a (2k)

    Thanks,

    Now, a few more questions......

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

    Re: Office 2000 and sr 1a (2k)

    Even in SR1 I don't trust it, and it sucks up resources and causes database bloat. If I find I absolutely *must* rename a query down the road, I use SpeedFerret (<A target="_blank" HREF=http://www.speedferret.com>http://www.speedferret.com</A>) or Rick Fisher's Find and Replace (<A target="_blank" HREF=http://www.rickworld.com>http://www.rickworld.com</A>). I don't usually rename queries down the road, because the names are only meaningful to a developer, and they can figure it out. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> As you might expect, my users never see the names of the queries, so cosmetic issues don't apply. <img src=/S/nope.gif border=0 alt=nope width=15 height=15>
    Charlotte

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office 2000 and sr 1a (2k)

    Charlotte and kaplinb
    Thanks for the advice. I took it and everything's still working fine.
    This thread seems to have wandered off on its own since my original request but thanks any way.
    Peter

Posting Permissions

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