Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Exclamation Unanswered: HELP! Need Access DB to show realtime changes in different location

    Hi Guys,

    I was wondering about how access refreshes it's data within forms and it seems that it doesn't.
    If i have a form open in one location on a network and update fields on the form the changes are not shown on the form opened in another location.
    (I.e. if 2 users are in the same form at the same time and one adds a new record the other users form will not show this change).

    Is there anyway that Access can be setup to show real-time changes over multiple locations?
    Preferably without having to do a manual refresh by clicking a button or something.

    All i want to do is show changes to a form instantly in different locations.

    Any help would be greatly appreciated.



  2. #2
    Join Date
    Jun 2003
    I have the same problem 2 years ago ;-)
    I have a combo box (in a form ) in which I need real-time information. The salvation was :

    Private Sub Form_Activate()
    Dim ctlCombo As Control

    ' Return Control object pointing to a combo box.
    Set ctlCombo = [Name of Your combo box]

    ' Requery source of data for list box.
    End Sub

    I hope to be helpful with this information ;-)

Posting Permissions

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