Ado recordsets and Access 2010 runtime

[lizray]

I have a database using ADO recordsets and it works perfectly in ACCESS 2010. I then Make an mde file and it also works well in ACCESS 2010. I tnen copy the mde file to another computer using ACCESS 2010 Runtime and I get errors right away. I tracked it down to the ADO statements. I then changed from ADO to DAO recordsets and went through the same process and it then worked perfectly on the ACCESS runtime. Can anyone help??
This is the code I used:
Dim rst2 As New ADODB.Recordset
rst2.Open "Names", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
strPrinterName = rst2.Fields("CurrPrinter")

 

[lizray]

Oops ! sorry I forgot to mention the Developement environment producing the MDB files was on Win7-64bit and the Access 2010 Runtime was on WinXP

 

[vbajock]

When you compile your MDE, you might want to set the ADO reference to 2.6, that version seems to run fine on all machines I encounter, later versions may not have a DLL present for later versions on your host machine if it is some 2003 XP box or something. It is a very stable version and I have yet to find any common functionality missing from it, if there is something in your code that requires a later version it will tell you when you run debug/compile. If that is the case, you will need to put an installation package together to install the correct DLL on your target machine along with the MDE, you will find them here:

http://msdn.microsoft.com/en-us/data/aa937730

 

[Goondu]

Note that in MS Access forum that there are still ongoing issues(bugs) with ADO. Not that I recalled was the problem was resolved yet.

So far, I find the older version of ADO 2.1 work better in Windows 7 and Access 2010.