" There was an error executing the command"

  • Thread starter Thread starter tracktraining
  • Start date Start date
T

tracktraining

Hi All,

I created a db which has a switchboard with 4 forms and 4 reports options. I
turned it into a mde and thus allowing other people in my company to use it.

For a couple of my coworkers, one of the 4 forms on the switchboard is not
working (always the same form and same computer). The form is unable to open
and gives the following error message "There was an error executing the
command". when I tried opening the forms on other coworkers computer, it
worked (it opens).

Please provide some suggestions/advices/comments.

Thanks,
Tracktraining
 
How do i know that my error handling is good or not? is there a "good error
handling" method?
 
thanks for the advice about adding error handling everywhere. I did that to
my code. Then I created an .mde. I ran the .mde on a coworker's computer, I
get this error "2544 Training Database can't find the you referenced in the
Object Name argument". How do i get to the reference location to see what
reference is missing if the computer doesn't have access installed? That
computer only have the runtime 2007.

thanks!
--
Learning


ruralguy via AccessMonster.com said:
Good really means *everywhere*. Are you displaying an error message or at
least logging every error? I suspect you have a procedure that is throwing an
error that does not have an error handler in it so the Run Time is just
dumping you out to the OS.
How do i know that my error handling is good or not? is there a "good error
handling" method?
You need good error handling in all of your procedures when you convert to an
MDE otherwise you get that generic error message and Access closes.
Click to expand...
[quoted text clipped - 14 lines]
Thanks,
Tracktraining
Click to expand...
Click to expand...

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
thanks!
--
Learning


ruralguy via AccessMonster.com said:
This link may be useful:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
thanks for the advice about adding error handling everywhere. I did that to
my code. Then I created an .mde. I ran the .mde on a coworker's computer, I
get this error "2544 Training Database can't find the you referenced in the
Object Name argument". How do i get to the reference location to see what
reference is missing if the computer doesn't have access installed? That
computer only have the runtime 2007.

thanks!
Good really means *everywhere*. Are you displaying an error message or at
least logging every error? I suspect you have a procedure that is throwing an
Click to expand...
[quoted text clipped - 9 lines]
Thanks,
Tracktraining
Click to expand...
Click to expand...
Click to expand...
 
Back
Top