Record sync on a LAN

[mcnewsxp]

my users are complaining that that don't see added record from other
workstations still they shut down and restart the app. anyway to remedy
this?

tia,
mcnewsxp

 

[NetworkTrade]

presuming you have a split database with each user having their own
frontend....one doesn't need to shut down / restart - but one does have to
refresh.

data is pulled in when opened...ie. a form, combobox, query etc......

for the data to be updated that form/query (generically speaking "object")
must refresh. you can close and reopen that object or in code make the
object refresh/requery.

Access is event driven. So you must figure out a trigger to
refresh/requery, maybe a timer, or maybe - as I do - just explain to users
they must close and reopen.

 

[Linq Adams via AccessMonster.com]

Actually, ***Refresh*** only shows ***changes*** that have been made to
***existing*** records, it doesn't show new records that have been added or
remove deleted records from view, To do these things you do need to Requery
the form.