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

John Bartow john at winhaven.net
Thu Mar 31 12:47:29 CDT 2011


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




More information about the AccessD mailing list