I have never used Access before, but a job is available to me which
consists of entering Medical Records in a Access 2000 database for a
doctor. He has another person working on the project but needs more help.
What I am wondering is if it is possible to merge databases, and how one
would go about doing so... ie. the first person is entering the records for
the first part of the alphabet, and I will be entering the remainder of the
records (from separate computers). Can the file I create then be merged
with the existing database to create a complete database? Thank you for any
help.. it is much appreciated!

mrWhite wrote:
Yes.

Perhaps one suggestion is to have a table called Master. Make a copy of
the structure ( click on Master table to select, then press CTLR+C then
CTRL+V) and enter MasterAtoL. Do that again fbut call this table
MasterMtoZ.

Now create a query. Click Query tab, New, Design. Select MasterAtoL.
If you don't have an autonumber as the primary key, drag the * down to
the first column...otherwise highlite all fields (click first field,
move to last field and press Shirt key then click on last field). Drag
those to the first column.

From the menu, click on Query, then select Append. Select Master. Save
it and call it AppendMasterAtoL

Now create another query with the above steps but use MasterMtoZ and
call the query AppendMasterMtoZ

When you are ready to append the records to the master, simply select
the query you want to run.

There is a flaw to this logic. If you appended 10 record then added 10
records and then ran the query, it'd append all 20 in the second time.
How to correct? You could add a field to the table called Appended.
After you run the query to append, you'd run an Update query that would
set the Appended field to True. And in the AppendMaster queries drag
the field Appended to the column and in the criteria fow enter False.

This assumes you are both working off site and you are passing the table
back to the central site.

If you are working onsite, the best method is to create a form. If you
don't have a form to add and edit records, click on FOrms, new, wizard,
and select the Master table and select the fields you want on the form
and follow the steps. There won't be anything fancy to it or any error
checking but you can at least be entering records to the table at the
same time.