Access data entry

[Guest]

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?

 

[Joseph Meehan]

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?

Yes. There are several ways including using a LAN and splitting the
database. Replication and using a link and an append query depending you're
your needs.

If you have no idea what I was talking about I suggest you look up
Replication in the help file as that will likely be the easiest for you to
do.

 

[John Vinson]

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]