Error 2950. Only on some PCs! Need help URGENT!

[Pantinosm]

Hi to everyone. So my problem is very strange for me. I have a ms access db in 2007 format. My db plays perfectly on my machine, but when i copy it on other machines, in some i get error 2950, that states ÖLE server has to be restarted outside Access.

I get this error in a form, when i try to select a combo box option, and then it pops up the 2950 error.
This doesn't happen in my machine. I found a solution somewhere that stated to put my program in trusted location, this didn't help either.



I will attach my db. The faulty combo is in Patients form.

Thank you in advance for your help.myprog.zip

[burrina]

Most likely this is caused because the db is not in a trusted mode.

[June7]

Why are there two unbound comboboxes with the same RowSource?

I don't use macros, only VBA. I converted macro to VBA and get a different error message. I tested the DoCmd code in immediate window:

Works:
DoCmd.SearchForRecord acDataForm, "Patient's Form", acFirst, "PID=2"

Does not work:
DoCmd.SearchForRecord acDataForm, "Patient's Form", acFirst, "PID=" & Forms![Patient's Form].Combo42

Advise not to use spaces, special characters/punctuation (underscore is exception) in names. Better would be PatientForm or Patient_Form, not Patient's Form. Even after I renamed form still get errors.
This gives 'Out of memory' error:
DoCmd.SearchForRecord acDataForm, "PatientForm", acFirst, "PID=" & Form_PatientForm.Combo42
This gives 'Automation error':
DoCmd.SearchForRecord acDataForm, "PatientForm", acFirst, "PID=" & Forms!PatientForm.Combo42
This works:
x = 2
DoCmd.SearchForRecord acDataForm, "PatientForm", acFirst, "PID=" & x

So macros and VBA are not recognizing the db objects.

This is very weird.

[Pantinosm]

Burrina, I put the db in trusted location, still doesn't work, and macros are enabled. Anything more?

June7, and other weird is that it works on my machine.

[June7]

I tried importing everything to a new db and still won't work. Sorry, I got nothing.