M
moondaddy
I have an application using MS Access 2003 and one of its menus keeps
disappearing from time to time. It may be OK for months and then it will
just disappear from the application and I have to import another one from a
backup copy of the application. This menu is used as a popup menu when I
right click on a 3rd party grid control. Depending on the data in the grid
row that's being right clicked on, I make certain menu items visible or not
visible. I also insert group dividers in code as well. All the code I use
with the menu is standard VBA code so I don't think I'm doing anything that
would corrupt the menu when the code executes. Sometimes when the menu
disappears is when I zip up a copy of the mdb and post it on an ftp server
for the client to download. When they download it and use it they find that
the menu is missing. I then download the same file from the ftp server and,
yes, the menu is missing. To double check, I run the copy of the mdb on my
machine which I made the zip file from and it's OK. So it appears that
sometimes the process of zipping the app and transferring the zip file
across the internet corrupts it in some way. I have seen this scenario a
number of times, but the problem is not limited to zipping and transferring.
Sometimes it just happens. Additionally, it only happens to this one menu
and not the others (and the other menus also get modified via similar code).
Any ideas on how to solve or trouble shoot this problem? The client has
expressed that they are becoming very tired of this issue.
Thanks.
disappearing from time to time. It may be OK for months and then it will
just disappear from the application and I have to import another one from a
backup copy of the application. This menu is used as a popup menu when I
right click on a 3rd party grid control. Depending on the data in the grid
row that's being right clicked on, I make certain menu items visible or not
visible. I also insert group dividers in code as well. All the code I use
with the menu is standard VBA code so I don't think I'm doing anything that
would corrupt the menu when the code executes. Sometimes when the menu
disappears is when I zip up a copy of the mdb and post it on an ftp server
for the client to download. When they download it and use it they find that
the menu is missing. I then download the same file from the ftp server and,
yes, the menu is missing. To double check, I run the copy of the mdb on my
machine which I made the zip file from and it's OK. So it appears that
sometimes the process of zipping the app and transferring the zip file
across the internet corrupts it in some way. I have seen this scenario a
number of times, but the problem is not limited to zipping and transferring.
Sometimes it just happens. Additionally, it only happens to this one menu
and not the others (and the other menus also get modified via similar code).
Any ideas on how to solve or trouble shoot this problem? The client has
expressed that they are becoming very tired of this issue.
Thanks.