Access 2010 SP1 – You receive random crashes in certain database or when opening the VBA window in those databases after installing Office 2010 SP1

Access has been my bread and butter from time to time over the years. And I have a lot to be thankful for. Many was the time that people told me something is impossible on Access. And time and again I was able to prove them wrong.

I am sad to say that I agree with Mike. I told my husband just yesterday that if something does not happen very soon with a long lasting effect that I will have no choice but to move to a different platform.

I have read in technical magazines that Access is no longer a priority for MS and did not want to believe it. This situation is obviously clear proof.

What disappoints me is that my customers are mainly people with smaller businesses who cannot afford expensive licenses. Microsoft Access has always fit this niche of the market perfectly.

S

I have been following this thread for a while now and have never made a post, but think I should speak up.

First, let me thank the Access team for all that you have done over the years. I visited you all and presented my Access app to the team back in July of 09 in Redmond. Since 2.0, Access has put literally $ millions directly into my pocket. I say this not to brag, but to hopefully establish that I'm both grateful and to set a reference point as to the magnitude of my concern.

I don't recall ever saying a negative thing about Access or its team, as I understand that the market will eventually win out on what the team does or does not do with this long running Office stepchild.

My point though is to voice the thoughts that I had long feared over the past 4 or 5 years - that is, that Access is becoming a lesser priority for Microsoft. Even more so, less a priority for the Access "developer". I believe that there is little I can do about this, since MS has put far more research and thought into the long-term viability of this product with regards to profitability for the company. Simply put, Access as a development platform turns a nice profit for me, but not MS. I would be willing to bet that the rate of "new" Access developers entering into the market, at best, has increased at a decreasing rate. I think this is evident now, more than ever, by the way that this bug is being handled. This = SP1, which any normal Office 2010 customer would accept and install, breaks all serious Access apps. I know that "all" is a strong word, but I would gladly welcome a correction.

Let's be honest here - I cannot tell thousands of my paying customers to uninstall SP1 nor expect them to decompile my app every 4 or 5 sessions for several months until MS fixes what their Service Pack broke.

I do not know what is going on internally in the fix department, but on the outside, releasing a Service Pack that blows my app out of the water with no solution for months, speaks volumes for what I am to expect in the future. It is unfortunate, but I believe that unless I begin the transition to another platform over the next year, I only have myself to blame when (and I do mean "when") we as developers are left standing with our pants down again.

Sorry to rant. Nathan - you have been a true sport for putting up with us and being our "go to" guy. This is nothing against you, and actually, like I said, nothing against MS. It's just a matter of circumstance.

Mike

Ah ha.

I just spoke with my network admin and he cleared this up for me.  He scheduled me for the sp1 update again on 10/13/11, along with the security updates you mentioned.

But from what you're saying, the cumulative updates, which have not been released yet, will hopefully solve the issue.

Well, I'll just keep working right along then.  I've been in and out of this database all day with no problems.

Hi Kris,

I believe the October security updates came out earlier this week, but I believe these updates are different than the Office cumulative updates.  So unfortunately, I don’t know that these updates will resolve the issue.  Once the October cumulative update for Office is released, I will post back to this thread.

Best Regards,

Nathan O.

Microsoft Online Community Support