Is there a roll-up for the 2003 SP3 hotfix?

[Clif McIrvin]

Is there a roll-up for the 2003 SP3 hotfix?

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

There are other users in our office who have not been using Access but
will likely begin using the app(s) I'm working on and will need to be
updated.

We're all running Office 2003 SP3.

I know where and how to get the hotfix I'm using, but don't even really
know where to look to discover if there are any newer updates I need.

Thanks in Advance!

 

[Tom Wickerath]

Hi Clif,

I don't know of any source from Microsoft that lists all hotfixes. Generally
speaking, they want you to apply a hotfix only if you are experiencing a
specific problem. Allen Browne shows one other hotfix on this page:

Bugs introduced by SP3 for Office 2003
http://allenbrowne.com/bug-Access2003SP3.html

See the section at the bottom "Other hotfixes for Access 2003", which shows
hotfix 970623.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Clif McIrvin]

Thanks, Tom. guess I should have mentioned that I'd checked Allen
Browne's site first <smile>.
I havn't experienced the out of memory issue; but I do have combo boxes
that don't work without the first hotfix.

Clif

 

[Tom Wickerath]

Hi Clif,

... but I do have combo boxes that don't work without the first hotfix.

Correct me if I'm wrong, but I seem to remember that this was only a problem
if the row source for the combo box included 31 or more columns (for example,
basing the combo on a wide table, instead of a query that restricts it to
just the needed fields). If my memory is correct, wouldn't a better fix be to
adjust the row source, so that it is not pulling so many fields?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Clif McIrvin]

Hi Clif,


Correct me if I'm wrong, but I seem to remember that this was only a
problem
if the row source for the combo box included 31 or more columns (for
example,
basing the combo on a wide table, instead of a query that restricts it
to
just the needed fields). If my memory is correct, wouldn't a better
fix be to
adjust the row source, so that it is not pulling so many fields?

Yes, it would. I'd never clued in to that; I'll check it out.

Here's the row source for one of the combos:

SELECT DISTINCT [xs Cylinder Lots Query new].Location
FROM [xs Cylinder Lots Query new]
ORDER BY [xs Cylinder Lots Query new].Location;

I'll try saving that row source as a saved query and see if that makes
it work w/o the hotfix.

xs Cylinder Lots Query new is a union query (which returns 22 columns)
working off a linked spreadsheet with 68 columns. (I have five sets of
data on each row in the spreadsheet -- the union query returns five rows
for each row in the spreadsheet.)

One of my goals is to replace that spreadsheet with tables and forms ...
but that's still off in the hazy future somewhere.

This is digging about in early development of my app ... before I'd

 

[Clif McIrvin]

Hi Clif,


Correct me if I'm wrong, but I seem to remember that this was only a
problem
if the row source for the combo box included 31 or more columns (for
example,
basing the combo on a wide table, instead of a query that restricts it
to
just the needed fields). If my memory is correct, wouldn't a better
fix be to
adjust the row source, so that it is not pulling so many fields?

Allen Browne's site states:
1.. Combo boxes go blank if their RowSource is a table field that has
something in its Format property.

2.. Access 2003 crashes if a combo's RowSource is a table with more
than 31 fields.


I have two unbound text boxes with format properties which do not allow
user data entry; also another unbound combo box with a row-source of a
saved query that returns one column -- which also does not permit data
entry. I speculate that the conditional formatting in the sub-form
(continuous form view) may be somehow related.

Unless someone has other suggestions for me to try, I plan to install
the hotfix where the app is needed as all works just fine with the
hotfix.

Clif