AccessBlog.net: Workaround for “Win 7 SP1 breaks ADO”: Tips and tricks, news, links, downloads on Microsoft Access

Thursday, August 25, 2011

This is a follow-up to Windows 7 SP1 breaks ADODB, here a MS KB article with typelibs, you can download, which resolves the issue:

An ADO application does not run on down-level operating systems after you recompile it on a computer that is running Windows 7 SP 1 or Windows Server 2008 R2 SP 1 or that has KB983246 installed

Labels: Access, VB, VBA

7 Comments:

Pat Wood said...: Hi Alex,

I can not find a fix for VBA in the KB listed in your post. A fix is supplied for VB6 however. Also I can find no announcement of a fix for VBA on the Forum http://social.msdn.microsoft.com/Forums/en-US/windowsgeneraldevelopmentissues/thread/3a4ce946-effa-4f77-98a6-34f11c6b5a13/

Have you tried method 1 in the KB article and found that it fixes the issue for Microsoft Access and VBA?; 11:59 PM
Alex Dybenko said...: Hi Pat,
i did not tried it on VBA, but i thing it should work in VBA. just register tlb as written in article and change references to new typelib.
But i recommend to use late binding for ADO, i do so from very beginning, when we got similar problem in ADO 2.1. I just had to fix activex dll, build by somebody else, which has ado connection in public interface, and in order to keep binary compatibility i had to use this tlb.; 10:12 AM
Pat Wood said...: Thank you very much for your input about this issue. I always read your posts because you write about the most important subjects pertaining to Access development and I appreciate it very much.

It has been 6 months now since Microsoft was notified of the problem and they have yet to provide an official fix. Right now they are telling us to develop on computers that do not have Windows 7 SP1 installed. But as more business and individuals begin to migrate from XP and Vista to Windows 7 the issue will cause more problems especially for Power Users who may not be aware of the issue.; 5:02 PM
Alex Dybenko said...: Thanks Pat, appreciate your feedback!; 9:11 AM
Anonymous said...: Alex, I've been having problems with SP1 since end of July. Here's the MS forum where developers have complained . . .

http://answers.microsoft.com/en-us/office/forum/office_2010-access/access-2010-sp1-you-receive-random-crashes-in/d2bf6175-075a-4a12-a2b1-f55d40af271b

and the response on Sept 27, 2011 ...

Hello Everyone,

There has now been a KB article published for this issue.

2625046 - Access 2010 crashes in VBE7.DLL after installing Office 2010 SP1

http://support.microsoft.com/default.aspx?scid=kb;EN-US;2625046

As mentioned in the article, a fix to the VBE7.dll will hopefully be released in the October 2011 Cumulative update.

Best Regards,

Nathan O.
Microsoft Online Community Support

I've uninstalled SP1 last week and things are OK right now. Am hopeful for a permanent fix this month.

Alex, I love your blog!

Paula
Wisconsin - USA; 4:35 AM
Alex Dybenko said...: Thanks for comment, Paula, hope we get it this month!; 9:37 AM
Alex Dybenko said...: Microsoft response to the issue:
http://blogs.msdn.com/b/psssql/archive/2011/10/03/yes-we-made-a-mistake-and-are-finally-going-to-fix-it.aspx; 5:16 PM