unknown run-time error

[cmarsh]

The database works perfectly fine in runtime with 5 out of 6 users. The 1
user can open the database with runtime, but errors out upon opening a form
from a command button.
The error "Execution of this application has stopped due to a run-time
error. The application can't continue and will be shutdown."
I can not seem to capture this error even with any logging, as it does not
show up.
However, when the user enters the database in design mode, he gets runtime
errors 2427 and 2105 continously, which again, works without any errors on 5
other user's computers.

Any suggestions?

Any suggestions?

 

[Klatuu]

Your post has some contridictory statments, so I need to get some things
clear before we can fix this. First you said:
The 1 user can open the database with runtime

Do you mean the runtime version of Access?

But then you say:
when the user enters the database in design mode, he gets runtime errors
2427 and 2105 continously

You can't even enter design mode in the runtime version and, both the error
code you reference are run time errors you should not be getting in design
view.

If the users actually have a full install of Access, I would check the VBA
references for the user who is experiencing the problem to be sure they are
the same as the other users.

 

[Klatuu]

There is no reason to use or even have installed the runtime version for
users with full installs.

I would suggest you run your code in debug mode so you can step through it
line by line to see what is causing the crash. Most of the time when one
user is having troubles the other are not, it is a VBA referance problem.

The only way to get a clue now is to debug on the user's computer to see
exactly what is happening. line by line.