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!

Error 2105 is "You cannot go to the specified record", not "Recordset not
updateable".

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.

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

Chris


JohnLute wrote:
Show quoteHide quote

Hi, Chris. Thanks for your response.

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.

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.


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!

BE/ FE Question
vba opendatabase readonly
record level lock access 2002
Security Problem When Linking Tables
can't disable shift key with faq_DisableShiftKeyBypass function
ACCDE
RWOP and passing variables to a function
Maintaining and updating Access 2007 database
Change Ownership of Database Object (?)
fastest way of distributing a split and secured database