Problems Access database information updating on network

[Guest]

I created a shared database on the network. Individuals then came back to me
saying that when one makes changes to it, it doesn't even appear on the other
persons system. They all used the shortcut that I gave them, so it is the
same database. This problem has existed for a few days now.

 

[John Vinson]

On Tue, 4 Jan 2005 07:31:04 -0800, Living Proof <Living

I created a shared database on the network. Individuals then came back to me
saying that when one makes changes to it, it doesn't even appear on the other
persons system. They all used the shortcut that I gave them, so it is the
same database. This problem has existed for a few days now.

Is this a split database, with each user having a "frontend" with
forms, queries, etc., and sharing a single "backend" database with the
tables? If not... you really should do so.

If it is split, be aware that Forms automatically "refresh" to display
changes in the values in existing records (every minute or so, I don't
recall the default time interval); but a form must be Requeried to
show new records. Closing and opening the form would do it, or you
could put a command button cmdShowNew on the form with

Private Sub cmdShowNew_Click()
Me.Requery
End Sub

to bring the form up to date with new additions from other users.

John W. Vinson[MVP]