Jun 09 2020 08:43 PM
Hi
I've got a subroutine in Access 365 vba which has been working fine for a few years and this morning threw an "Run Time error '7': Out of Memory". I have the same routine running over several windows 10 pcs (all producing an excel workbook for different people all at the same time).... 2 pcs still work the rest - including the PC where I created the accdb file are throwing the error. I've done some tracing and now in the dao.recordset when I'm referencing rs.Fields(counter).value what is being returned is rs.Fields(counter).Name for a few fields and then access crashes. and what appears in the cells are not numbers which I would be expecting - either the field name appears or
꽸꺈翹 |
Does anyone have any ideas? where I can go to next?
Jun 09 2020 09:00 PM
Solution@graemelever Unfortunately, a bug has been identified in a recent update to Access. Scroll down the linked discussion for the explanation from the MS Access Team PM.
It's build 2005. If that is the version you are now using and which is throwing these errors, you should roll back to the prior version. If that's NOT the problem in your case, perhaps a compact and repair will clear the problem.
Jun 09 2020 10:55 PM
Thanks - I thought it was going to be update related (I was fearing the worst and thinking I had a massive corruption somewhere) - I've followed you lead and i'm back up and working again.....Thanks Heaps! @George Hepworth
Jun 10 2020 05:37 AM
@graemelever Congratulations on solving the problem. Continued success with your project.
Jun 09 2020 09:00 PM
Solution@graemelever Unfortunately, a bug has been identified in a recent update to Access. Scroll down the linked discussion for the explanation from the MS Access Team PM.
It's build 2005. If that is the version you are now using and which is throwing these errors, you should roll back to the prior version. If that's NOT the problem in your case, perhaps a compact and repair will clear the problem.