Run-Time Error 2501 on DoCmd.Save

One of my users is receiving run time error 2501 when the following statement is executed:

DoCmd.Save acForm, "frmXYZ"

I can perform the same action from my system without an issue, and I have 30 other users who havent encountered this problem.  I am leaning towards this being an issue with not having the proper version of something (such as MDAC) installed.

Thanks in Advance,

- Michael

mjs082969Asked:
Who is Participating?
 
stevbeConnect With a Mentor Commented:
DoCmd.Save acForm, "frmXYZ"

this saves the property changes to the form object itself ... is this what you are really trying to do or just save the record?

Steve
0
 
shanesuebsahakarnCommented:
If you are trying to save the record, use:
Forms!frmXYZ.Dirty=False

Or from within the form itself:
Me.Dirty=False
0
 
LucasMS Dynamics DeveloperCommented:
Or you can also use this command to save a record:

DoCmd.RunCommand acCmdSaveRecord
0
 
mjs082969Author Commented:
The intent of the code was to save the record, not the entire form.

Thanks for the information!

(Although, I am still curious as why this only happened to one user, and not all of them)
0
 
stevbeCommented:
perhaps they have Runtime and not full version of Access?
0
All Courses

From novice to tech pro — start learning today.