By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

MS Access in Citrix, Macro skipping events without warning

P: 1
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
Aug 13 '07 #1
Share this Question
Share on Google+
2 Replies


Scott Price
Expert 100+
P: 1,384
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
Aug 13 '07 #2

P: 1
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
Aug 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.