Question Multi users database: users to see changes in real time

[sm80]

Hi All,

I have a database that has been split and the front end distributed to users. Any changes made by the users are not showing in real-time to other users. They have to close it and reopen for the changes to appear.

How can i get it so any changes to the database are displayed in real-time to all users?

Thanks

S

 

[pr2-eugin]

Could you explain your situation a bit more.. when you say "The changes are not showing".. Do they all have access to tables? What changes are they making?

 

[sm80]

I have attached a screen shot of the database.

For example:

If USER A and USER B both have their front end open.

If USER A makes a change, they have to then close their copy. Then USER B has to close their copy and reopen it to see USER A's changes and vice versa.

They are all linked to the same back end and have access to the same tables. I just want any changes made by any user to appear to all users in real-time, without the need for users to close and reopen their front ends to see the changes.

Does this make sense?

S

 

[Galaxiom]

If you are looking directly at the tables then the changed records will only appear when the view is moved to a different "page" of records and back again or the table is reopened.

However users should never be looking directly at tables. They should be viewing forms.

Changed records are shown when the form is "Refreshed".

New records only appear when the form (or its recordset) is "Requeried".

These processes can be done in VBA. Otherwise the form can be closed and opened again to requery its recordset.

 

[sm80]

Are you able to direct me to somewhere that talks me through how i can do this as?

 

[jkl0]

You can use the On Timer Event to do a requery of the form
and, the Timer Interval to tell the event how often to trigger.
(Timer Interval is in miliseconds)
But, be careful about setting the Interval to low or it will cause a lot of screen flicker and possibly interfere with other events.