Bill Patten
bill_patten at embarqmail.com
Sun Apr 10 01:14:18 CDT 2011
Thanks for the update Gustav, Finally showing that the problem effected more than dot net and 32/64 client issues helps, and had I known that 2 weeks ago would have probably saved me some time. I am lucky, I only have 2 clients using my ADP's at this time. Both are fully developed and are just in a maintenance mode so I don't have to work on them very much. The problem with both clients was solved by transferring the application to one of my XP machines, decompiling, and recompiling in the XP Machine and shipping to the clients. I still don't understand why some PC's worked and some didn't but now they all work. Since my machine caused the problem, (Win 7 64 SP1) I don't think I should bill my clients so I'm sure I can send the bill for 10 hours of trouble shooting and testing to Microsoft. Ya Think? Bill -------------------------------------------------- From: "Gustav Brock" <gustav at cactus.dk> Sent: Saturday, April 09, 2011 1:54 AM To: <accessd at databaseadvisors.com> Subject: Re: [AccessD] Using ADO and Windows 7 SP1? Be careful! Hi Bill et al There is a lengthy discussion on this here: http://social.msdn.microsoft.com/Forums/en-US/windowsgeneraldevelopmentissues/thread/3a4ce946-effa-4f77-98a6-34f11c6b5a13 However, it doesn't add much as the essentials seem to be updated in the KB article posted below by Doug. /gustav >>> bill_patten at embarqmail.com 31-03-2011 20:27 >>> I am having similar problems with 2 clients. I just moved an ADP Access 2003 from my development machine (Win7 64 SP1 ) to an XP machine, decompiled it, set the reference to activex 2.6 from 2.7 recompiled, repair and compacted and shipped it. It now works on one machine that it did not work on. They will let me know later about the other machines as people start to use the application. What is really strange it always worked on some of their machines and we were not able to find any differences in versions or references. The second client is running it on Windows Server 2003. I have access to it using LogMeIn so will experiment tonight to see if changing the active x reference, or decompile compile on an XP machine or both fixes it. Many other people seem to be removing SP 1 from their development machines, but I'd rather not go backwards, course I've been known to cut off my nose to spite my face. If I learn anything new tonight I'll let you all know. Bill -------------------------------------------------- From: "Doug Steele" <dbdoug at gmail.com> Sent: Thursday, March 31, 2011 11:09 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Using ADO and Windows 7 SP1? Be careful! I believe so, from reading the discussions. I was able fix the problem by removing the ADO reference on the client machine, compiling (got errors on missing reference) then reinstating the reference and compiling once more. I'm not sure if the first compile step does anything, but it doesn't do any harm. Doug On Thu, Mar 31, 2011 at 10:47 AM, John Bartow <john at winhaven.net> wrote: > Hi Doug, > Just for clarification purposes, if the compiled access database running > ADO > is compiled on anything older than W7SP1 does it still work correctly on > W7SP1? > > John B. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele > Sent: Wednesday, March 30, 2011 9:59 PM > To: Access Developers discussion and problem solving > Subject: [AccessD] Using ADO and Windows 7 SP1? Be careful! > > I had a call from a client this morning. Some code that I had written > using > ADO to write records to a back end, code which has been working for 2 or 3 > years, was crashing with a message indicating that ADO wasn't working. > Unfortunately, it was a bit of a panic situation and I didn't get a screen > dump of the message. I putzed around with the references and > re-compiling, > and got it to work. Turns out that this is probably an example of a known > problem: > > http://support.microsoft.com/kb/2517589 > > There is also a discussion (well, a bunch of bitching) about this in the > LinkedIn Access Developers group. If I understand it correctly, an Access > database using ADO which is compiled on a computer running Windows 7 SP1 > will NOT run properly on any other version of Windows. > I`m running Win7 SP1 and my client is Win7, so I guess this was the > problem. > > I wonder if I can send an invoice for my debugging time to Microsoft... > > Doug -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com