recordset not updatabale

  • Thread starter Thread starter JohnLute
  • Start date Start date
J

JohnLute

I have a small, secured application that's split into FE and BE files with
the BE placed on a server for global access over a WAN (I can hear your
groans).

Be that as it may (reality can be ugly) I need help understanding an error
I'm getting which is 2105.

The FE is saved to local machines. The FE links to the BE. From my PC I
login as a full data user and experience no problems. Several others can also
run it without problems, however several others get the 2105 error.

Today I logged onto one of our "problem" PC's and then opened the database
with no issues. Great! I logged off the PC and the owner of it logged on and
tried to run the database. Guess what? 2105!

This doesn't make sense. He used the SAME database login that I used.

Has anyone run into this before?

Thanks!
 
Hi, Chris. Thanks for your response.
Error 2105 is "You cannot go to the specified record", not "Recordset not
updateable".
Click to expand...

That's true. Some users have experienced forms loading with "Recordset not
updateable." briefly displaying in the help text area of the window.
Afterwards, the 2105 error returns when trying to move from the displayed
record.
Logging in with different user names means different permissions and
different files available from the different profiles. It's not guaranteed
for two profiles to get the same results when opening the same file in the
same pc.
Click to expand...

Also true however we use Access as an enterprise program I can't imagine
what different permissions I might have that these others don't.

Please post your code and show which line of code is causing the error.
Click to expand...

It's an intermittent problem and sometimes points to this:
Private Sub Form_Load()
If Me.OpenArgs = "New" Then
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End If

End Sub

This form is opened via a command button:
Private Sub OpenComplaints_Click()
On Error GoTo Err_OpenComplaints_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmComplaints"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , , "New"

Exit_OpenComplaints_Click:
Exit Sub

Err_OpenComplaints_Click:
MsgBox Err.Description
Resume Exit_OpenComplaints_Click

End Sub

Thanks!
 
Back
Top