Multiple users of shared Access db cannot see new records entered by others

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cambar
    New Member
    • Jul 2010
    • 20

    #1

    Multiple users of shared Access db cannot see new records entered by others

    The database is on a shared network drive and one form primarily is used to enter new records. If user A enters records, user B cannot locate these records through the form unless user B first closes and then reopens the data entry form. What needs to be done to enable entered records to be seen by all users once entered, without having to close and reopen the data entry form?

    Thanks

    camgar
  • munkee
    Contributor
    • Feb 2010
    • 374

    #2
    What is your database set up? I assume you have the database split into front and back end?

    Comment

    • cambar
      New Member
      • Jul 2010
      • 20

      #3
      The database is not split at this point. Only have 3 users accessing the form on a regular basis and the number of records is fairly small

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32669

        #4
        Forms which have already loaded their data will not update unless and until they are either closed and re-opened, or they are Requeried.

        Comment

        Working...