Auto update in other PC

[AstonCheah]

i am currently running a database which is more on information sharing. how do i run a code when i update my data on my PC and the other PC will also be updated automatically at the same time (they don't have to refresh their PC).

can anyone help?

thanks.

 

[DCrake]

From what you say you do not have a front end back end configuration.

You need to split the data tables away in a new database then link these table to the orignal database using the Linked Tables Manager.

Then place your back end on a shared server
Install the front end on each users PC and make sure they can see the path to the shared back end. This way all users will be looking at the same data all the time.

 

[AstonCheah]

DCrake,

thanks for you help, but i've never done the front end back end configuration, and i am not able to catch you idea. can you share with me step by step on how to do it? by the way, i am using m/access 2007.

will truly appreciate you help.