Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error using Find (97)

    For a database on a shared location users receive an error message when using the Find tool, to the effect that 'mutiple users are trying to access this information' and the system tends to crash. I haven't seen the database yet, but if I check the Record-Locking options and check that only one form is open at the time, what other reasons might cause this to occur? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error using Find (97)

    If users are trying to find records using Edit | Find... or the "binoculars" button on the toolbar, record locking shouldn't be involved, for record locking only kicks in when someone starts editing (modifying) a record, not when users are just viewing records. Is the "Find tool" something programmed by the person who designed the database? If so, what is the code for it? Or is there code that modifies records while moving from record to record?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error using Find (97)

    More info. The Find feature they're talking about is actually Filter by Form. They have one form open which shows records from tblCorrespondence. Might it be that, on the form, there are drop-down lists to assign an employee to the correspondence, but the employee details are held in a separate table (tblEmployees) without there being a relationship between the two tables?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error using Find (97)

    When a user filters a form, then closes it, Access will try to save the form design (with the filter.) This can lead to conflicts in a multi-user environment.

    By far the best solution is to split the database into a back end that contains only the tables, and a front end that contains links to the tables in the back end plus all other database objects (queries, forms, ...). Give each user his/her own copy of the front end.
    If you prefer to use a shared front end, you must ensure that users cannot save the design of forms, for example by making an .mde file. Or hide the close button in the upper right corner of forms, and provide a command button that closes the form without saving the design:

    Private Sub cmdClose_Click()
    DoCmd.Close acForm, Me.Name, acSaveNo
    End Sub

    Note: acSaveNo does NOT mean that the current record won't be saved, only that design changes (such as applying a filter or sort order) will not be saved. Access saves records automatically.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error using Find (97)

    Excellent, Thank you.

Posting Permissions

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