By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Error 2105 from "Add New" Command Button

rsmccli
P: 52
Using AC2002

Hello. I am working with an existing DB that has "Add New" command buttons on two forms.

When I, an Admin, click the buttons, they work properly, and a new, blank form is created, ready for data entry.

When one of my users from the "Update Data" workgroup clicks the button, they get an "Error 2105: You can't go to the specified record" error, and no new row is created. Each of these are just supposed to add a new row in their respective tables.

Could this just be a security issue; I'm assuming so because Admins can use the button. However, I changed the table permissions to allow Open/Run, Read, Update, Insert, and Delete on all tables and am still having issues. Here is the code behind one of the buttons without errorhandling
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdAddRec_Click()
  2. On Error GoTo ErrorHandler
  3.  
  4. ' add new record
  5.   Me.AllowAdditions = True
  6.   DoCmd.GoToRecord , , acNewRec
  7.  
  8. ' set focus to first data entry field
  9.   Me.Plant.SetFocus
  10.  
  11. End Sub

Any help is appreciated.
Feb 14 '08 #1
Share this Question
Share on Google+
3 Replies


rsmccli
P: 52
Also notable is that it appears that the new record is being made, because the first time an "update user" clicks the button, there is no error, only the second and third, etc. button clicks produce the error. They are just not able to navigate to the new record using the navigation buttons, as "admins" can.

Thanks again for looking.
Feb 14 '08 #2

rsmccli
P: 52
bump Update Data users can manually create a new field in the table... Allow Additions property is set to "yes" even though this is taken care of in code also...
Feb 14 '08 #3

P: 1
How did you resolve this issue, because I am having the exact same problem
Sep 16 '10 #4

Post your reply

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