S
Snowsride
My daughter is setting up a small business with a friend - they will work
from different locations but will need to share a database which I am going
to create. They only have laptops so I need a method to synchronise any
changes to the tables. So far I've considered setting up a daily routine
using an export table option and then having each of them email the files to
the other which hopefully can then somehow be synchronised with the current
mdb tables.
I have no experience with data access pages but could I make use of them for
my purposes? From initial investigations it looks as if they can't be used
to add records they can just be used to edit or delete records?
This is clearly not going to be a very elegant method of working since it
will depend on both users remembering to run the routine at the end of each
working day but the volume of business is likely to be low so investing in a
server cannot be justified financially.
Grateful for any ideas.
from different locations but will need to share a database which I am going
to create. They only have laptops so I need a method to synchronise any
changes to the tables. So far I've considered setting up a daily routine
using an export table option and then having each of them email the files to
the other which hopefully can then somehow be synchronised with the current
mdb tables.
I have no experience with data access pages but could I make use of them for
my purposes? From initial investigations it looks as if they can't be used
to add records they can just be used to edit or delete records?
This is clearly not going to be a very elegant method of working since it
will depend on both users remembering to run the routine at the end of each
working day but the volume of business is likely to be low so investing in a
server cannot be justified financially.
Grateful for any ideas.