Page 1 of 1

any tip for network shared database .mdb?

PostPosted: Sat Jan 14, 2017 7:28 am
by yanzco
i need help,
i am trying to have a database being shared to a local network..

what i'm trying is being able to have a network computer to sync data when a button is pressed "sync"..

what i did..
main computer A
i have the shared file main database.mdb
shared file changes.mdb

network comp B
has its own database.. user.mdb but whenever the app is opened, it copies the whole database.mdb file and renames it to user.mdb then uses it..

now when a network comp does a change it will add the changes to another database changes.mdb

but then now i get confused as it gets complicated//

i dont know how to use mysql database. as im stuck with access database.. using simple add records and delete records..

help :(

Re: any tip for network shared database .mdb?

PostPosted: Sat Jan 14, 2017 9:36 am
by virger
I would try to do it this way, but before I ask:
1) Do you make "changes", "insertions" and "erased" on both computers?
2) NO == Then when finished "copy" the base that was used / change to the other computer
3) YES == Then with the information of DatabaseChanges you should compare "Time of Change" "NumRegister" and thus know where to go. Ex.
Change Compu "A" Time = 9:00 AM Record = 15
Change Compu "B" Time = 9: 01 Record = 15
The Compu B Data must be passed to Compu A
Inserts and deletes run on both computers
Compu "A" insert 56, copy it to Compu "B"
Compu "B" insert record 61, copy it to Compu "A"
Compu "A" Delete record 76, Delete it in Compu "B"

I have not tried
Trataria de hacerlo de esta form, pero antes pregunto:
1) Haces "cambios","insercciones" y "borrados" en ambas computadoras?
2) NO==Entonces al terminar "copia" la base que se uso/cambio a la otra computadora
3) SI==Entonces con la informacion de la DatabaseCambios debes comparar "Tiempo del Cambio" "NumRegistro" y asi saber de donde a donde pasar. Ej.
Cambio Compu "A" Time=9:00 Registro=15
Cambio Compu "B" Time=9:01 Registro=15
Se debe pasar la Data de Compu B a la Compu A
Las inserciones y los borrados se ejecutan en ambas computadoras
Compu "A" inserto resgistro 56, copiarlo a la Compu "B"
Compu "B" inserto resgistro 61, copiarlo a la Compu "A"
Compu "A" Borro resgistro 76, Borrarlo en Compu "B"

Yo no lo he intentado

Re: any tip for network shared database .mdb?

PostPosted: Sat Jan 14, 2017 6:34 pm
by yanzco
yes, both computers can do changes..