Access 2013 RecordSetCLone Issue

[MrDagz]

Hi I have an application that is an access front end for an SQL server DB. this application works fine in access 2003 through to 2010 but when I try to run it in 2013 it starts asking me to select a data source every time it encounters code that refers to a recordsetClose object.

one example is the line me.RecordsetClose.movelast and other is If me.RecordSetClose.EOF then

if I select a DSN file it will the carrier on and work fine.

any one have any idea why this happens and how I can fix the issue?

 

[pr2-eugin]

Hello MrDagz, Welcome to AWF..

Why not assign the RecordetClone to a Recordset object and see if this helps?

Dim someRS As DAO.Recordset
Set someRS = Me.RecordsetClone
[COLOR=Green]'use the object as..[/COLOR]
someRS.MoveLast

 

[superpine]

Hello MrDagz, I'm having similar issue after upgrading from Access 2010 to Access 2013, did you ever resolve this issue?

 

[bobalston]

Me too. same problem.

Anyone?

bob

 

[The_Doc_Man]

Those of you who upgraded to Office 2013: You have an option as to whether you get the 32-bit or the 64-bit version of Office, and I believe that the default changed for Office 2013. Open a database, then from the ribbon's "File" tab, select Account - then open the "About Access" dialog box by clicking on the About feature in the middle of the screen. If you have some Ac2010 still installed, do the same for those machines.

The libraries for the 32-bit and 64-bit versions are NOT the same, so it is possible that if you changed "flavors" you might have switched libraries silently. There is (unfortunately) no guarantee of consistent behavior between the 32-bit and 64-bit functions. You'd think they should be alike, but we ARE talking about a Microsoft product here. Cross-version compatibility? Hah! Hah, I say! Hah!