[AccessD] Using ADO and Windows 7 SP1? Be careful!

Jim Lawrence accessd at shaw.ca
Thu Mar 31 16:00:33 CDT 2011


I have to do that with a number of clients. Upload the source, remove the
references, re-add the reference and then compile...two passes usually
solves the issues.

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten
Sent: Thursday, March 31, 2011 11:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Using ADO and Windows 7 SP1? Be careful!

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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list