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

Hi John,

Unfortunately, like other users have mentioned, I have seen this same type of error happen in Access 2010 before SP1 was installed and in other versions of Access, so it is tough to guarantee some update caused it.  With that being said, there always is a chance that an update could have caused another issue.  If we can pinpoint a certain update that is causing the issue or if you can find a way to consistently reproduce the issue, then it may be beneficial to start a new thread to address that issue.  The problem with reporting all these issues in this same thread is it makes it tough to follow all of the different questions that are being asked or scenarios people are running into.

If in fact you need this to be addressed immediately, then your best option will be to open a case because as mentioned, unless we have a way to isolate the problem and get a consistent repro of the issue, there isn’t much I can do to narrow down the problem.

Best Regards,

Nathan O.

Microsoft Online Community Support

Nathan,

Understand re the function of the Hotfix.  The point was that

1. the embedded macro behind the main form button was a simple instruction to open another specified form.
2. I had never had any error with that simple embedded macro either before OR after installing the fix. After installing the fix, I had been working on that database yesterday (including routine use of the button concerned) and had not had any problems developing or using it.
3. After installing the last batch of Office 2010 updates last night, I then did have the Return without Gosub error immediately today, when I opened the database and clicked on that main form button as I had done countless times before
4. Removing the embedded macro and replacing it with a VB instruction to open the form removed the Return without Gosub error

Logically, the problem may associated with one of the 2 or 3 Office 2010 updates I noticed were included in this last patch Tuesday batch. This is clearly something which needs to be brought to the attention of the teams concerned, since 2 developers have so far had the same error. No doubt others will follow.

We are not really interested in whether it was the fix or the other Office 2010 updates or some lack of integration between them. Rather than creating different threads, all we request is that you bring this to the notice of the teams concerned so that they can jointly look at any interactions between the fix and these last updates in respect of embedded macros.

Hi Paula,

I would definitely move forward with installing the fix, especially if you already have SP1 installed.  I’m not sure what other issues you have seen reported after installing the fix, but from what I can see it has worked for the majority of the users that installed and it should resolve your crashing issue.

Best Regards,

Nathan O.

Microsoft Online Community Support

I have not tried the hotfix due to all the issues reported here.  I cannot chance it that my Users will have other issues.

I have decompiled access.exe, and followed the instructions to recompile each database app that I develop ... and IT HAS WORKED temporarily - like for a day.  But I am delighted that I can at least develop for 8 hours with no issues, and go through the decompile process again when needed.

I've followed Roger's instructions here ... and it works!

http://rogersaccessblog.blogspot.com/2009/04/how-do-i-decompile-database.html

Paula