Access 2003 post SP3 hotfix - combo box and list box controls and others

[Tony Toews [MVP]]

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007
http://support.microsoft.com/kb/945674

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Salad]

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007
http://support.microsoft.com/kb/945674

Tony

Maybe SP3 was released to get people to move to A2007.

 

[Richard]

Hi Tony

Many thanks for the information.

Is the service pack 3 installed automatically with office updates? How do I
check if I have the service pack installed?

should I install the service pack, then install the hotfix ( if its not
installed)?

Many thanks in advance
Richard

 

[Tony Toews [MVP]]

Is the service pack 3 installed automatically with office updates?

It might not be. I've only been prompted for it when using Microsoft
Update.

How do I
check if I have the service pack installed?

Help >> About. The very first line on that form should end in SP2 or
SP3.

should I install the service pack, then install the hotfix ( if its not
installed)?

There's one bug with SQL Server that might not yet be fixed. But I
think the hotfix fixed most of the problems. I'd still wait a week
or three.

A2003 SP2 is pretty stable in my opinion. It has its warts but I can
live with this.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Richard]

Hi Tony

Many thanks

Richard

It might not be. I've only been prompted for it when using Microsoft
Update.


Help >> About. The very first line on that form should end in SP2 or
SP3.


There's one bug with SQL Server that might not yet be fixed. But I
think the hotfix fixed most of the problems. I'd still wait a week
or three.

A2003 SP2 is pretty stable in my opinion. It has its warts but I can
live with this.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Richard]

Hi Tony

The first line has just Microsoft Office Access 2003 (11.5614.5606)

Does that mean that SP 2 has not been installed?

Thanks again
Richard

 

[Tony Toews [MVP]]

The first line has just Microsoft Office Access 2003 (11.5614.5606)

Does that mean that SP 2 has not been installed?

Yup, you don't even have SP1 installed. I'd suggest at the very
least installing SP2.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John W. Vinson]

Is the service pack 3 installed automatically with office updates? How do I
check if I have the service pack installed?

Open Access; select Help... About Microsoft Access. It will say what service
pack is installed at the end of the top line of the window.

should I install the service pack, then install the hotfix ( if its not
installed)?

Microsoft will probably provide the hotfix only if you contact them directly
with documented evidence that the bug in SP3 is causing you problems. See the
Knowledge Base article in Tony's post.

John W. Vinson [MVP]

 

[Richard]

Hi Tony

should I skil SP1 and install SP2?

Will there be any problems if I install SP2? The database is working fine
now without any problems. I am afraid it might create problems if I install
anything.

Richard

 

[Tony Toews [MVP]]

Maybe SP3 was released to get people to move to A2007.

Ouch.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

should I skil SP1 and install SP2?
Yes.

Will there be any problems if I install SP2? The database is working fine
now without any problems. I am afraid it might create problems if I install
anything.

Well, if you aren't having any problems then I'd wait a bit more and
see what SP3 is like after the hotfix.

There is a slight risk of malware due to uninstalled patches for
security holes such as buffer overflows. However that's unlikely in
an Access MDB as we've only seen one so far. And that was due to a
problem in Jet and not Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

Microsoft will probably provide the hotfix only if you contact them directly
with documented evidence that the bug in SP3 is causing you problems. See the
Knowledge Base article in Tony's post.

Actually you can download the fix right from that KB article. Which
is unusual.

Also now most hotfixes can be requested via a link at the bottom of
the KB article. Just put in your email address and you'll be sent an
email with the fix. MS likes to know what folks have what hotfixes in
case a notification needs to be sent out if there are bugs that that
hotfix creates.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Baz]

Yep, SP3 is a turkey. I've had to ask all my customers not to install it,
and those who have installed it to uninstall it (which is not as simple as
it sounds...)

 

[George Nicholson]

Just put in your email address and you'll be sent an

email with the fix.

Huh, I thought MS had a long standing policy of *never ever* sending files
via email. (So you always knew it was a scam if you got an attachment
claiming to be from Redmond).

Maybe that only applies to mass mailings, and not specific requests such as
this.
Or does the email simply contain a link?

 

[Tony Toews [MVP]]

Huh, I thought MS had a long standing policy of *never ever* sending files
via email. (So you always knew it was a scam if you got an attachment
claiming to be from Redmond).

Maybe that only applies to mass mailings, and not specific requests such as
this.
Or does the email simply contain a link?

The email contains a link.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Larry Linson]

Is the service pack 3 installed automatically with office
updates? How do I check if I have the service pack installed?

Yes, SP3 was installed on my machine without explicit request. I am signed
up for automatic Windows/ Office Updates.

Open Access, under Help on the menu, choose About Access 2003. That will
tell you if you are at the SP3 level.

should I install the service pack, then install the hotfix ( if its not
installed)?

That would be the appropriate order of operations.

I do not know if the hotfix is automatically sent with Updates. It might be
worth your following the hyperlink at determining whether it is instaled.

Many thanks in advance
Richard

You are welcome.

Larry Linson
Microsoft Access MVP

 

[Tony Toews [MVP]]

I do not know if the hotfix is automatically sent with Updates.

Highly unlikely. Once it's been more thoroughly tested it'll
probably be converted to a regular patch.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Eric]

But still no fix for the Checkbox issue?