updating through query, change gets reflected elsewhere?

[Lifeseeker]

Hi,

Perhaps this is a dumb question but...

The database is split into backend and frontend. When users make changes to data(changing values and updating numbers) through the front end in query, for example, will other users will able to see the changes immediately when the change happens?

I've noticed that users would have to hit "refresh" every time to see the latest result in report. I guess I could tell users to hit "refresh" button everytime they run the report, but is there any way around this?

Some kind of requery or refresh code might be needed for reports?

Comments/thoughts much appreciated.

 

[pbaldy]

No such thing as a dumb question. In a standard setup, the data is changed on the back end and all users should see the new info. That said, if a user already had a form or report opened when the data behind it changed, they would not automatically see the new data. You would have to requery the form. If this is a common thing, you can put a requery in the timer event of the form. I do that in reservation/dispatch applications so the dispatcher will automatically see new reservations being input by others.

 

[Lifeseeker]

Hi,

Thanks for posting back.

I have noticed that the report screen actually gets reshuffled everytime there is an update logged. (this is with the timer built in)

Users would just like to view the report either on screen or have them printed out, but I guess I can increase the interval to maybe....10 minutes...

It's just that if both the person viewing the report and the person doing the update have the database open, then the change won't get reflected right away, but I guess the chances of this happening is rather slim.

maybe I will just increase the timer or find a way to hold the report screen still.

Any thought?