Results 1 to 8 of 8
  1. #1
    Join Date
    May 2004
    Posts
    133

    Angry Unanswered: Urgent need help - error 2105: cannot goto specified record

    Hello
    I have frondend on my local PC, backend db located on my Lan so that
    multi-user can access backend concurrently.
    I already implemented "Security Wizard" to control my users. But I found
    very strange prob that if I assigned to A user only "Read-only" permission or
    only "update-only" permission in "User/group account", when A use opened
    frontend db on him desktop, an error message displayed:
    =========================
    Runtime error-'2105':
    Cannot goto specified record
    ==========================
    I clicked "debug" button on this error message and it pointed to
    "Me.textsearch.SetFocus" of "onload" event as below:
    ==========================================
    Private Sub Form_Load()
    Me.textsearch.SetFocus
    Me.lstcomtor.Visible = False
    Me.lstyear.Visible = False
    Me.lstmonths.Visible = False
    Me.Lstdate.Visible = False
    Me.GroupList.Visible = False
    Me.Lst_updated_comtor.Visible = False
    Me.custList.Visible = False
    Me.prjList.Visible = False
    Me.cmbsort.Visible = False
    Me.btn_import.Visible = False
    Me.JPwordList.Visible = False
    End Sub
    =======================================
    Could anyone let me know is there a way to fix it?
    Thanks in advanced

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I don't see how Me.textsearch.SetFocus could really the villain here, SetFocus having nothing to do with going to a record. I suspect that it's being highlighted simply because it's the first line of code as the form is loading, and that the real problem is with the Record Source of the form. Perhaps someone else can shed some light. If no restrictions are placed on this user in "User/group account" can he/she does the form load without a problem?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    May 2004
    Posts
    133
    If no restrictions are placed on this user in "User/group account" can he/she does the form load without a problem?
    > Yes. If no restrictions are placed on this user in "User/group account", he/she does the form load without a problem.
    Ex: New data user, full data user, full permission user, admin.
    This problem only occurred in case user is read-only permission user or update-only permission user.
    Thanks
    P/S: I also have backup db file before implemented "Security wizard", no problem occurred.
    Could anyone can help, I really need your help
    Thanks in advanced.

  4. #4
    Join Date
    Jul 2005
    Posts
    39
    Is it possible that the form runs a query which user A does not have permission to run?

  5. #5
    Join Date
    May 2004
    Posts
    133
    No, I already checked the query permission of user A. All queries is reading query structure and reading data. I think there is no prob with it.
    Very strange prob. I'm very confused. Could anyone give me some hints?

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I'm grasping at straws here, much like yourself. I still think Me.textsearch.SetFocus is only singled out because it's the first code line in the Form_Load sub, and that the problem is arising before this point. The only thought that comes to mind is that there's a conflict between the Properties set for the form, i.e Allow Additions = YES, Allow Deletions = YES, Allow Edits = YES and the "read-only" or "Update-only" status granted some users. Might be worth investigating.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    May 2004
    Posts
    133
    OK. thanks for advice. I will investigate it and report you later.
    Thanks

  8. #8
    Join Date
    May 2004
    Posts
    133
    Thanks. you are right. there's a conflict
    thank you. you are expert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •