MS Access in Citrix, Macro skipping events without warning

[davidratz]

I run Access 2000. We still have Access 97 resident on our server. We run all of this inside of a Citrix environment. I have a macro which runs a dozen or so queries and macros. At the end of the macro, and within several of the macros, there are several e mails that are supposed to send. The macro is running and completing the beeps I have at the end, but it is skipping some events and not stoping and posting a halt notice. If I copy the macro, I can run it, and once it runs, I have to delete the events which ran correctly, save it, close Access, reopen it and then run it again until the next failure. Upon each failure, I repeat the above. Any help would be greatly appreciated. David

[Scott Price]

I run Access 2000. We still have Access 97 resident on our server. We run all of this inside of a Citrix environment. I have a macro which runs a dozen or so queries and macros. At the end of the macro, and within several of the macros, there are several e mails that are supposed to send. The macro is running and completing the beeps I have at the end, but it is skipping some events and not stoping and posting a halt notice. If I copy the macro, I can run it, and once it runs, I have to delete the events which ran correctly, save it, close Access, reopen it and then run it again until the next failure. Upon each failure, I repeat the above. Any help would be greatly appreciated. David

Just a general comment on M$ Access macros in general: They do not allow error handling.

This means that you are most likely suffering from some unhandled errors in your macro(s).

It's a labor intensive task to convert them to VBA code, but could be well worth the effort, especially since VBA code is magnitudes easier to troubleshoot, and DOES allow error handling and trapping.

Regards,
Scott

[certifiedguruCisco]

David. I had a similar issue but I contact Seth at www.adaset.net and they fixed my issue. Not sure what they did but it worked, I have 30 servers in my farm.

I run Access 2000. We still have Access 97 resident on our server. We run all of this inside of a Citrix environment. I have a macro which runs a dozen or so queries and macros. At the end of the macro, and within several of the macros, there are several e mails that are supposed to send. The macro is running and completing the beeps I have at the end, but it is skipping some events and not stoping and posting a halt notice. If I copy the macro, I can run it, and once it runs, I have to delete the events which ran correctly, save it, close Access, reopen it and then run it again until the next failure. Upon each failure, I repeat the above. Any help would be greatly appreciated. David