Can databases be merged to update data?

M

Mark

Recently, two employees worked on the same database at
two different locations on two different workstations.
After we entered data into the databases, we cannot seem
to merge our information back into one database. Atleast
the help files didn't provide a solution here. Can
anyone direct us to the appropriate newsgroup if this
isn't the site for the answer we are seeking? If you can
answer our question and provide us with the information
to merge our databases into one of the databases, please
help. Thank you in advance.
 
J

John Nurick

Hi Mark,

Working with copies of your databases, use File|Get External Data|Link
to make the table(s) in one database available in the other. Then use an
Append query to copy the records from the linked table to the table with
the existing data.

Recently, two employees worked on the same database at
two different locations on two different workstations.
After we entered data into the databases, we cannot seem
to merge our information back into one database. Atleast
the help files didn't provide a solution here. Can
anyone direct us to the appropriate newsgroup if this
isn't the site for the answer we are seeking? If you can
answer our question and provide us with the information
to merge our databases into one of the databases, please
help. Thank you in advance.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Top