...as a further thought, if it's Access 97, I think you can perform partial replication (based upon queries) which might be a possible solution (although I think it changes auto-sequence keys to random GUID's).