Forum home » Delegate support and help forum » Microsoft Access Training and help » Merging databases
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Merging databases
Resolved · Urgent Priority · Version 2003
Reply Tue 16 Sep 2008, 10:26Delegate Sammie said...
Sammie has attended:
Access Intermediate course
Access Advanced course
Merging databases
My colleagues have updated different versions of our contact database. Is there any way of combining the most recents entries they've made into one version? There aren't any overlap contacts so hopefully it's possible.
Many thanks!
Sammie
For upcoming training course dates see: Pricing & availability
RE: Merging databases
Hi Sammie
Thank you for your question
Could you clarify the following for me please
1. Is the contact data that you wish to transfer stored in a single table, with additional tables storing data on other subjects (e.g Companies?)
2. What is the nature of the contact table's primary key field. Is it an autonumber?
Thanks
Stephen
Reply Tue 16 Sep 2008, 16:20Delegate Sammie said...
RE: Merging databases
Thanks for your reply.
1. The contact data is in one table but it does link to other tables eg. company table, employee table etc.
2. The primary key is indeed an autonumber.
|