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
in spilt database why changes not appears in other computers immediately
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: in spilt database why changes not appears in other computers immediately
Do you mean changes to the data?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: in spilt database why changes not appears in other computers immediately
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
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
Re: in spilt database why changes not appears in other computers immediately
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?
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?
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: in spilt database why changes not appears in other computers immediately
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.
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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
Re: in spilt database why changes not appears in other computers immediately
Thank you very much for all these information.
Kind regards
Kind regards