468,134 Members | 1,216 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,134 developers. It's quick & easy.

Runtime error of '2501' with multiple users when saving

10
Recently installed a small Access (2003) application for a non-profit association which I wrote on my home pc. Copied the database to a share volume and the Access mde to another shared volume with a short key set up for it. Application starts up fine and user is able to key in records (forms using data entry property), access current data via another form and modify the data on the form. A save record button was created for the user by using the Access command button feature from the tool bar. Everything works fine with one user but if we have multiple users, when someone makes a change and hits the Save Record button, a "Run time error of 2501" is generated. It doesn't seem to matter what the other user is doing. Looking at the VB code generated by Access:
Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_cmdSave_Click:
Exit Sub

Err_cmdSave_Click:
MsgBox Err.Description
Resume Exit_cmdSave_Click

End Sub

Any suggestions? Looking at other "2501" posting, I don't see anything similar.

Thanks for your help,
BobS
Oct 1 '10 #1
0 981

Post your reply

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

Similar topics

4 posts views Thread by Keith | last post: by
1 post views Thread by keithb | last post: by
27 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.