"Sharktyyfa" <sh********@sharktyyfa.com.tw> wrote in
news:42******@clear.net.nz:
Access 2003, WinXP.
I have built a database that uses synchro to co-ordinate with the
mothership.
All is well.
The person i built it for wants the satellites to be able to edit
the entries in their database until it is synchro-ed(sic?) with
the mothership.
At that point they should only be able to add new entries and not
edit existing records.
Is this possible?
Not at the replicated table level, but you can certainly set up your
application to disable record editing in your data editing forms.
You'd have to decide exactly how to do that. One way would be to
check the connect string on the tables, and if they are connected to
the mother ship, allow editing, but if they are connected to a local
replica, disable editing in the form's OnOpen event.
Of course, that assumes that your tables are secured by some method,
and the best way, of course, is with Jet user-level security. But
that can be cracked by someone who wants to do so.
There is no reason, per se, to limit edits in a replicated app --
they will be synched. The problem, of course, is that unless you
write your own conflict resolver routines, you don't have full
control over which edits win.
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc