Is it possible to enter data into duplicate copies of the same Access Data
sheet using separate machines (to save data entry time) and then merge the
tables or data?
If the two machines are on the same (reasonably stable and fast) local
area network, then the answer is even better: you can have a single
shared database containing the Tables, linked to up to 255 (formally,
in practice thirty or forty) "frontend" databases. These contain only
the forms, reports, and queries, and have links to the shared
"backend" database. Tools... Database Utilities... Database Splitter
Wizard will set this up for you.
All the users can concurrently insert and update data in the shared
tables. The only thing they can't do is concurrently edit the same
record.
John W. Vinson[MVP]
