Access crushes after SP3 installed

[Guest]

Hello all,

I hope someone can help me with the following problem;
This problem started after I install Microsoft Office 2003 SP3

After several hours of investigation I strip my problem to following simple
steps

1) Create a table (e.g. Products) with more then 30 fields in it (e.g. 1,2,3
.... 31 )
2) Create a form (Form1) add combobox to it (e.g. Combobox1).
3) Save Form1
4) Open Form1 in design view again
5) Set Combobox1's "Row Source Type" to be "Table/Query" and "Row Source" to
be "Products", where "Products" is table created at step 1 above
6) Try to save Form1 and it will lead to "Microsoft Office Access has
encountered a problem..." dialog box with "Send Error Report" button in it
and consecutively shutting down Microsoft Access

Notes: If table has 30 or less fields when above problem does not happen

I would really appreciate your help!

Thanks,

 

[Allen Browne]

Hi Ed.

I am able to reproduce this problem in Access 2003 SP3.

On Vista, the save (your Step 6) failed with the message:
There isn't enough memory to perform the operation.
Close unneeded programs and try the operation again.
The second attempt, it crashed as you said.

The workaround is simple enough: click the Build button (...) beside the
RecordSource property, and create a query that has fewer fields.

Nevertheless, this is a nasty little problem. I will try to create a sample
and bring it to the attention of he MS Access Dev Team.

Thanks for pinning this issue down, Ed.

 

[biganthony via AccessMonster.com]

Ed,

This happened to me each time i attempted to save a form after deleting the
custom formatting of a field in a table underlying the form that experienced
the combo box problem after installing SP3. (Hope MS read the error reports
sent their way when this happened to me. There were about 6 of them!) The
only way I fixed it was by copying the database to a computer with SP2 and
making the changes there.

Regards
Anthony

 

[Guest]

Hi Allen,

Thank you for prompt response.
I would really appreciate if some one let me know that this problem will be
fixed by Microsoft!?

I followed your advice but problem is that query cannot have more then
10 fields, over wise same problem happen again.

The only work around that I may suggest is as following:

1) Temporarily reduce number of the field in the query to less then 11
2) Set combobox "Row source" to the query
3) Save the form
4) Open query in design view and add required number of fields
6) Save query
7) If required to edit form again then
a) Do step 1 above
b) Edit and save form
c) Do steps 4 and 6

I hope it will help to others until Microsoft will fix this nasty problem.

Don't you love Microsoft buggy upgrades?
Now I am just waiting what else will go wrong and of cause hips of call from
my clients with complains. Try to explain to them that it is not my mistake
in programming, but friendly upgrade from Microsoft.

 

[Gina Whipp]

Glad I saw this...

 

[Allen Browne]

Yes, since you are a developer, I'm sure you know how easy it is to
unintentionally cause another problem when you fix one.

If you are interested, the sample I prepared for MS to demonstrate the bug
is at:
http://allenbrowne.com/temp/A2003sp3bug.zip
and the message I sent linked to this thread (another another from Stephen
Young, I think it was.)

 

[Guest]

Hi Allen,

I checked your sample database for MS to demonstrate the bug. Good job,
it is clear and simple.

 

[Guest]

Hi biganthony,

I am personally do not using any type of formatting for a table. When I
start developing access databases around 11 years ago I read an article (do
not remember there) which recommended not to do any formatting on a table
level to avoid complication. So since when I follow this advice and keep my
tables format to bare minimum, and all formatting happening on form, module
or query level.

However even so this bug does not affect me directly, but I fill it still
should be fixed by Microsoft.

 

[Guest]

HAS ANYONE OUT THERE HEARD ANYTHING FROM MS YET ABOUT HOW TO FIX THIS? I NEED
HELP QUICK...WE HAVE BEEN HAVING SERIOUS PROBLEMS SINCE THURSDAY (9/27/03)
WHEN OUR AUTOUPDATES INSTALLED OFFICE SP3...

 

[Guest]

Please advise if there is a fix. I have to complete 3rd quarter reports.
Every table in my database has more than 10 fields. There is no way to
reduce them. I have tried to copy the database or create a new one and
import. I just imported the problem. I am in big trouble here.

 

[Guest]

Any updates?
I'm now getting this error after applying SP3 yesterday.

Outside of a hotfix, is the only resolution to uninstall Office 2003 and
reinstall without SP3?

thanks,
Michael

 

[Guest]

I had to totally uninstall Office, then reinstall. Then install SP2 to get
back to a working version. I am working fine now, although every computer in
here is receiving reminders to install the SP3 update. I have warned
everyone not to do it.

I am waiting for the "fix"

 

[Guest]

Yeah, I bit the bullet and uninstalled/reinstalled (to SP2) and now have a
working version again.

I usually wait longer before applying updates. I am reminded again as to why.

Beyond the frustration of the initial problem, I was also frustrated that
uninstalling removed all my desktop shortcuts. I'm not talking about the
shortcuts created by the installer. I'm talking about the shortcuts I
created to load specific Access databases. I don't recall prior versions
doing that.

Michael