C
Can Of Worms
I have been given a 3rd party Access menu (essentially) which contains
buttons that open other access database front ends. The database which
contains this menu is written in Access 2003. The databases that it opens are
written in Access 97, 2000, and 2003. Originally the buttons were mapped to
macros that just used the "RunApp" macro command. I converted all the macros
into VBA, and added in error checking to avoid people trying to open front
ends that they don't have, avoid trying to open in a version of Access that
they don't have, and avoid trying to open front ends in versions older than
the version that the front ends were written in.
I re-released the menu interface to the field users, and some of them (less
than 20%) are running into an odd issue. 2 of the front ends (Access 2000)
are closing immediately after opening. They open just long enough to finish
drawing the interface, then close completely.
It only does this with 2 of the 4 Access 2000 front ends, not at all with
the 2 Access 2003 front ends, and not at all with any of the 4 Access 97
front ends.
It also only does this with less than 20% of the field users.
I have been thinking macro security level, other security level, code
protections, something like that is what is locking them out.
Any ideas?
buttons that open other access database front ends. The database which
contains this menu is written in Access 2003. The databases that it opens are
written in Access 97, 2000, and 2003. Originally the buttons were mapped to
macros that just used the "RunApp" macro command. I converted all the macros
into VBA, and added in error checking to avoid people trying to open front
ends that they don't have, avoid trying to open in a version of Access that
they don't have, and avoid trying to open front ends in versions older than
the version that the front ends were written in.
I re-released the menu interface to the field users, and some of them (less
than 20%) are running into an odd issue. 2 of the front ends (Access 2000)
are closing immediately after opening. They open just long enough to finish
drawing the interface, then close completely.
It only does this with 2 of the 4 Access 2000 front ends, not at all with
the 2 Access 2003 front ends, and not at all with any of the 4 Access 97
front ends.
It also only does this with less than 20% of the field users.
I have been thinking macro security level, other security level, code
protections, something like that is what is locking them out.
Any ideas?