VBA with ADO 2.8 work different in XP,Vista and 7

[giovanniroi]

Dear friends,
I have found that the VBA code of Access 2007 that uses ADO 2.8 connections work correctly in Vista and 7 if the code is compiled into an XP enviroment.
If the VBA code was compiled on Windows 7 the VBA code work well only in 7 and does not work in Vista and XP.
I found that ADO 2.8 libraries are different for all the systems XP, Vista and 7.

There is a way to solve this problem to compiled the code directly into 7 and to garantie the correct execution in Vista and XP?

Thank's for the support.

Giovanni Roi

 

[Galaxiom]

That is odd. What actually happens when it goes wrong?

 

[giovanniroi]

Dear Friends,
When I run the Access 2007 compiled code in Windows 7 on Vista or XP will be generates an error 2950 and when a see the code to find the reasons for the errors a see an error in the component ADO.
The problem is unsolvable, the only way to run the code is to compile it in an XP.

I'd like to know how it works Access, I thought it was the run time to execute the all the code but it is not. I think part of the code is compiled with the libraries of the system and that probably there s c compatibility problem between the ADO 2.8 library between XP, Vista and 7.

I hope you can help me solve the problem

Thank's.

Giovanni Roi

 

[boblarson]

Perhaps you should read this:

http://en.wikipedia.org/wiki/Microsoft_Data_Access_Components

and look specifically down in the history list with 2.7 and 2.8.

 

[giovanniroi]

Dear Bob,
thank's for the information. I have read the document link and that confirms what I suspected, that the incompatibility between the VBA code compiled with ADO 2.8 on Windows 7 with XP.
I sincerely hope that this anomaly be corrected in the future VBA release.
Thanks for the support.

Giovanni Roi