samthomasny
New Member
- Joined
- Nov 19, 2011
- Messages
- 9
I had a few Access files with vb scripts for running a bunch of queries using odbc to AS400 and then to the final summarized data I used to copy paste to pre-set Excel files. All of a sudden two days back it all stopped working. Access runs all the queries and get the final data I need, but it wasnt transferring those to the Excel file. The VB scripts came and stopped at this:
rst.MoveFirst
xlApp.Worksheets("InvDump").Range("B2").CopyFromRecordset rst
I baffled with this for a whole day. Then I checked the Windows Update and found there were a bunch of updates installed on 04/10/2014 for my 2010 64 bit Access. I uninstalled those updates and then tried my macros again. It worked like a charm. I am contemplating whether to turn off the auto-update.
rst.MoveFirst
xlApp.Worksheets("InvDump").Range("B2").CopyFromRecordset rst
I baffled with this for a whole day. Then I checked the Windows Update and found there were a bunch of updates installed on 04/10/2014 for my 2010 64 bit Access. I uninstalled those updates and then tried my macros again. It worked like a charm. I am contemplating whether to turn off the auto-update.
