Just confirming that either copy  (i.e. either computer system) gets write
access provided the other isn't also connected?

Also, what mechanism are you using to connect to Access? Can you show us
the code?