Forum Discussion
Changes to CutCopyMode in V1705+ causes problems with ODBC refresh function
Somewhere between V1701 and V1705 a change was made to excel which affects when CutCopyMode is returned back to false. You can see this using Excel normally if you copy something and see those crawl...
I've already solved it. The work around is to clear out the clipboard prior to doing the ODBC refresh command. Its a single command to a Microsoft Library, thus its impossible to resolve directly. The command is:
odbcCn.Refresh
where odbcCn is the object ODBCConnection
This project is using the Microsoft ActiveX Data Objects 2.8 Library, although i'm fairly certain i've tried a new version without success. This was a little while ago now.