Hi all,
I have been slowly developing my DB for 20 years and other than odd little issues it has been extremely stable. The DB users recently requested a basic means of allocating themselves and each other tasks. Rather than reinventing the wheel I used the MS Office Task Management template and largely copied across the tables and forms and then amended them to suit.
The task module works extremely well and everyone is happy with it however since rolling it out to all the users I now have an issue with Access randomly crashing on 4 of the 12 machines. To try and pinpoint the issue I set up a log and asked all users to record details of the crash, time/date/what they were doing/what form they were on. Sadly it has not shown any real patterns with the exception it is limited to 4 users out of 12.
Given the DB has always been so stable this pointed me to it potentially being an environment issue with those particular users and on further investigation it turns out the one common thing that all these users have in common that is different to everyone else is they have MS Access 365 64 bit on their machines where as everyone else who is not suffering any issues at all are running 32 bit.
Strangely prior to my task module implementation these 64 bit machines (which have been in service for approx 12 months) were not having any issues which is clearly shown in the computer management application logs which all show the crashes starting on the 64 bit machines on the day I implemented the task module.
It would be easy to blame some issue with the task module I built, however it is pretty basic with very little VBA code and also the 32 bit machines are not have any issues with it at all??
Does anyone else have any experience with this issue and any pointers to getting to the bottom of the issue?
Thanks
I have been slowly developing my DB for 20 years and other than odd little issues it has been extremely stable. The DB users recently requested a basic means of allocating themselves and each other tasks. Rather than reinventing the wheel I used the MS Office Task Management template and largely copied across the tables and forms and then amended them to suit.
The task module works extremely well and everyone is happy with it however since rolling it out to all the users I now have an issue with Access randomly crashing on 4 of the 12 machines. To try and pinpoint the issue I set up a log and asked all users to record details of the crash, time/date/what they were doing/what form they were on. Sadly it has not shown any real patterns with the exception it is limited to 4 users out of 12.
Given the DB has always been so stable this pointed me to it potentially being an environment issue with those particular users and on further investigation it turns out the one common thing that all these users have in common that is different to everyone else is they have MS Access 365 64 bit on their machines where as everyone else who is not suffering any issues at all are running 32 bit.
Strangely prior to my task module implementation these 64 bit machines (which have been in service for approx 12 months) were not having any issues which is clearly shown in the computer management application logs which all show the crashes starting on the 64 bit machines on the day I implemented the task module.
It would be easy to blame some issue with the task module I built, however it is pretty basic with very little VBA code and also the 32 bit machines are not have any issues with it at all??
Does anyone else have any experience with this issue and any pointers to getting to the bottom of the issue?
Thanks