How to make automatic refresh / realtime form datasheet

  • Thread starter Thread starter Erwin Sugiawan via AccessMonster.com
  • Start date Start date
E

Erwin Sugiawan via AccessMonster.com

fyi : database use SQL Server 2000 ,frond end use Ms.Access 2000 and
allready use with multi user

the problem is :
I want to automatic refresh / realtime form datasheet, if the data allready
changed, deleted or add new by another user

I try to solve it with
1. timer event + requery but i thing it's not a good idea because if data
not changes, the form will be allways requery.

2.I use winsock so every user change the data, the will be send an event
and i use arrived event to refresh form datasheet. And it's not solve the
problem again because prosedure save/add data is more slow than event send
data with winsock.

so guys , plx help me to solve the problem.


thx
Esugiawan
 
or have another table, listing "tabls" and "LastUpdate". As long as all data
updates are done via code / forms, it would be simple o update the
appropriate row.

Then, the timer would simply query this table, and compare it against then
the data was last refreshde (form level variable). If newer, do the refresh
 
Back
Top