in spilt database why changes not appears in other computers immediately

[siamandm]

Hello all
I have split a database to front and back end, and copied the front end to 4 computers, the changes appears after we close all the apps

do i need to put in the form an event to do so ?

Regards

[HansV]

Do you mean changes to the data?

[siamandm]

yes

[HansV]

It shouldn't be necessary to close the front end. If a user has already opened a bound form, they may have to requery or refresh it to see changes in the data. You might create a command button cmdRequery:

Code: Select all

Private Sub cmdRequery_Click()
    Me.Requery
End Sub

[siamandm]

thank you for the reply,
by default in split database updates of the data in tables happens immediately? or there is a technique like adding the me.requery to the forms?

[HansV]

The tables in the frontend are linked to the tables in the backend, so if a user adds or edits a record, the changes will be stored in the backend, and be visible to all users.

Let's say two users, user A and user B, have opened a form bound to the same table, and they are looking at the same record.
If user A edits that record, then moves to another record, Access will automatically save the changes to the record.
User B will not see those changes instantly because the original version of the record has already been loaded into memory.
User B will see the changes when they
- Move to another record, then move back. This will load the modified record.
- Close and reopen the form.
- Explicitly requery the form by clicking Refresh All on the Home tab of the ribbon.
- Explicitly requery the form by clicking a command button on the form created by you, with code as in my previous reply.

[siamandm]

Thank you very much for all these information.

Kind regards