Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    End of Recordset (Access 97)

    In a shared database when trying to add a record, users get the following error message. "You can't go to the specified record, you may be at the end of a recordset." I have posted this question in a previous post but didn't know the exact error message. Does anyone know how to prevent this from happening or why this error occurs.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: End of Recordset (Access 97)

    EmilyB has a similar thread going - it ususally has to do with error handling trapping something in the middle of an insert. I think your other thread in combination with hers may put you on the right track.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: End of Recordset (Access 97)

    Would you be using a normal Access data entry form or are you using a recordset? Have you got a front-end on each machine back end on server set-up?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: End of Recordset (Access 97)

    You can get that by doing a MovePrevious when you're at the first record, or a MoveNext when you are adding a record, i.e. you're trying to move beyond the current records in the table.

    It's error number 2105, so you can check for that number in your error trapping code and just do nothing (leaving you at the start or the end of the recordset as the case may be).

Posting Permissions

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